trees
508 rows where qSpecies_id = 25 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1940 | 43017 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 2319 | 34069 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 3439 | 43015 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 5259 | 45154 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | Permit Number 44007 | |||||||||||||
| 5523 | 38232 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 6572 | 34068 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 6767 | 38234 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 7060 | 38233 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 7097 | 34072 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 7436 | 43016 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 9043 | 43018 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
| 9398 | 264655 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1099 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
| 12809 | 38231 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 0 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40352 | |||||||||||||
| 14576 | 34071 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 16742 | 34070 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 17098 | 34067 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 11311 | 73919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007979.77962 | 2109750.06791 | 37.77342234081 | -122.415822718756 | (37.77342234081, -122.415822718756) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | ||||
| 13467 | 70988 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 179 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007961.92289 | 2109767.88075 | 37.7734702467743 | -122.415885749526 | (37.7734702467743, -122.415885749526) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||||
| 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 | |
| 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 | ||||
| 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 | |
| 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 | |
| 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 | ||||
| 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 | |
| 137615 | 31889 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 167 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 15 | Permit Number 35321 | 6007897.98767 | 2109828.50999 | 37.7736331256972 | -122.416111205987 | (37.7736331256972, -122.416111205987) | 8 | 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 | |||
| 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 | |
| 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 | |||
| 179490 | 87141 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 169 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767576 | 6007945.36003 | 2109780.43285 | 37.7735037807007 | -122.415943932067 | (37.7735037807007, -122.415943932067) | 8 | 2 | 9 | 28853 | 34 |
| 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 | ||||
| 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 | ||
| 636 | 67551 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.7613646282886 | -122.403117586111 | (37.7613646282886, -122.403117586111) | 10 | 3 | 8 | 28856 | 29 | |
| 993 | 67493 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.7606474054712 | -122.402272073209 | (37.7606474054712, -122.402272073209) | 10 | 3 | 8 | 28856 | 29 | ||
| 1568 | 172155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 649 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 6011250.4218 | 2091802.92791 | 37.7243267296922 | -122.403246295306 | (37.7243267296922, -122.403246295306) | 10 | 3 | 7 | 309 | 28 | |||
| 1757 | 261740 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 2735 | 262549 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 3 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | |||
| 3374 | 261742 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 3438 | 194171 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6011792.75247 | 2105015.27083 | 37.7606352745052 | -122.402300054726 | (37.7606352745052, -122.402300054726) | 10 | 3 | 8 | 28856 | 29 | |||
| 4771 | 261101 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1188 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
| 5885 | 261744 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 6826 | 261100 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011819 | 2093407 | 37.7287629192895 | -122.401393465775 | (37.7287629192895, -122.401393465775) | 10 | 3 | 8 | 58 | 1 | |
| 11749 | 200232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 3 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | ||
| 12728 | 256034 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1455 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015659 | 2093559 | 37.729393784799 | -122.388128823531 | (37.729393784799, -122.388128823531) | 10 | 3 | 8 | 58 | 1 | |||
| 12766 | 261739 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 13102 | 200235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | 10 | 3 | 8 | 58 | 1 | ||
| 14624 | 261099 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011819 | 2093407 | 37.7287629192895 | -122.401393465775 | (37.7287629192895, -122.401393465775) | 10 | 3 | 8 | 58 | 1 | |
| 14638 | 261745 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 14658 | 261743 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 15134 | 261076 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1188 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
| 16190 | 34502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1415 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1997 12:00:00 AM | 9 | Permit Number 38224 | 6013698.3172 | 2104744.62684 | 37.7599983314835 | -122.395690557494 | (37.7599983314835, -122.395690557494) | 10 | 3 | 8 | 28856 | 29 | |
| 16452 | 261741 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 16692 | 78621 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011632.94564 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | 10 | 3 | 8 | 28856 | 29 | |||
| 17201 | 72137 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013608.91395 | 2104739.63414 | 37.7599796489713 | -122.395999412568 | (37.7599796489713, -122.395999412568) | 10 | 3 | 8 | 28856 | 29 | |||
| 17567 | 150775 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2004 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 4x5 | 6012077.37529 | 2103767.84682 | 37.757226007585 | -122.401228007969 | (37.757226007585, -122.401228007969) | 10 | 3 | 8 | 28856 | 29 | |
| 18508 | 79749 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.389711390588 | (37.7638512843329, -122.389711390588) | 14 | 3 | 8 | 28856 | 29 | |||
| 19459 | 49782 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 327 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2020 12:00:00 AM | 3 | Permit Number 46567 | 6012093.71999 | 2087090.74144 | 37.711435076735 | -122.400000354248 | (37.711435076735, -122.400000354248) | 10 | 3 | 8 | 309 | 1 | |
| 22071 | 192422 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.7680909933277 | -122.401057281578 | (37.7680909933277, -122.401057281578) | 14 | 3 | 8 | 28856 | 20 | |||
| 30403 | 32983 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | ||
| 33588 | 192415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013731.20085 | 2104795.92406 | 37.7601410116297 | -122.39558042201 | (37.7601410116297, -122.39558042201) | 10 | 3 | 8 | 28856 | 29 | |||
| 39253 | 66067 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1425 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 12 | Permit Number 29107 | 6013650.29046 | 2104740.70593 | 37.7599848938155 | -122.395856385278 | (37.7599848938155, -122.395856385278) | 10 | 3 | 8 | 28856 | 29 | |
| 41661 | 49835 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.86383 | 37.7590565524297 | -122.393142029905 | (37.7590565524297, -122.393142029905) | 10 | 3 | 8 | 28856 | 29 | |
| 42236 | 66180 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.7600022642143 | -122.395600181905 | (37.7600022642143, -122.395600181905) | 10 | 3 | 8 | 28856 | 29 | |
| 42562 | 192418 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 2 | : | Tree | Private 2 | 9 | Width 5ft | 6013740.02795 | 2104156.22974 | 37.7583850412574 | -122.395505075892 | (37.7583850412574, -122.395505075892) | 10 | 3 | 8 | 28856 | 29 | |||
| 44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
| 45964 | 67574 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | 10 | 3 | 8 | 28856 | 29 | |
| 49729 | 192424 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012214.21558 | 2107593.00345 | 37.767736670334 | -122.401023519214 | (37.767736670334, -122.401023519214) | 14 | 3 | 8 | 28856 | 20 | |||
| 50638 | 192419 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 3 | : | Tree | Private 2 | 8 | Width 5ft | 6013725.78081 | 2104155.14731 | 37.7583812766799 | -122.395554273333 | (37.7583812766799, -122.395554273333) | 10 | 3 | 8 | 28856 | 29 |
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) );