trees
508 rows where qSpecies_id = 25 sorted by Longitude
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 | |||||||||||||
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 | |||
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 | ||||
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 | |||
109388 | 96194 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
55349 | 115881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.09601 | 37.737410632491 | -122.390459765022 | (37.737410632491, -122.390459765022) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | |||
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 | ||
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 | |
189015 | 192421 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 53 Pomona St | 1 | : | Tree | Private 2 | 2 | Width 5ft | 6014148.28892 | 2094395.14028 | 37.7316058387373 | -122.393410025148 | (37.7316058387373, -122.393410025148) | 10 | 3 | 8 | 58 | 1 | |||
58513 | 102247 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.7619482253485 | -122.394424198727 | (37.7619482253485, -122.394424198727) | 10 | 3 | 8 | 28856 | 29 | |||
91533 | 32276 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 9 | 6x6 | Permit Number 37277 | 6014077.27946 | 2105468.87126 | 37.7620080221813 | -122.394430611806 | (37.7620080221813, -122.394430611806) | 10 | 3 | 8 | 28856 | 29 |
183084 | 32275 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 11 | 6x6 | Permit Number 36861 | 6014077.35334 | 2105478.23544 | 37.7620337382821 | -122.394431011984 | (37.7620337382821, -122.394431011984) | 10 | 3 | 8 | 28856 | 29 | |
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 | ||
51882 | 32986 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
57421 | 32985 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
186605 | 32984 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |
82691 | 192420 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 4 | : | Tree | Private 2 | 8 | Width 5ft | 6013708.56182 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | 10 | 3 | 8 | 28856 | 29 | |||
79612 | 105962 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 6013706.37383 | 2104134.52437 | 37.7583235710722 | -122.395619946844 | (37.7583235710722, -122.395619946844) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |
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 | |
160751 | 192416 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6013651.01145 | 2104790.61421 | 37.7601219711709 | -122.395857388933 | (37.7601219711709, -122.395857388933) | 10 | 3 | 8 | 28856 | 29 | |||
191383 | 66066 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1431 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 11 | Permit Number 29106 | 6013625.10181 | 2104739.90322 | 37.7599812884231 | -122.395943445033 | (37.7599812884231, -122.395943445033) | 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 | |||
193185 | 119913 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013509 | 2106013 | 37.7634704729857 | -122.396434224989 | (37.7634704729857, -122.396434224989) | 14 | 3 | 8 | 28856 | 29 | ||||
83654 | 49830 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46613 | 6013486.20588 | 2106002.24827 | 37.7634396826096 | -122.396512309398 | (37.7634396826096, -122.396512309398) | 14 | 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 | |
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 | |
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 | |
141749 | 41187 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 380 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46607 | 6013185.95339 | 2105307.79412 | 37.7615161505792 | -122.39750208615 | (37.7615161505792, -122.39750208615) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||||
77221 | 32926 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1530 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 9 | Permit Number 37252 | 6012714.10584 | 2106606.08517 | 37.765054686045 | -122.399225162022 | (37.765054686045, -122.399225162022) | 14 | 3 | 8 | 28856 | 20 | |
171102 | 32928 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1550 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 11 | Permit Number 44256 | 6012662.29085 | 2106602.53119 | 37.7650420397834 | -122.399404128919 | (37.7650420397834, -122.399404128919) | 14 | 3 | 8 | 28856 | 20 | |
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 | |
81760 | 192405 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1900 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012343.89644 | 2104716.44706 | 37.7598455204762 | -122.400372895689 | (37.7598455204762, -122.400372895689) | 10 | 3 | 8 | 28856 | 29 | |||
112771 | 51725 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1904 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | 6 | Permit Number 48537 | 6012320.61849 | 2104715.41974 | 37.7598414015724 | -122.400453331067 | (37.7598414015724, -122.400453331067) | 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 | |||
137812 | 192423 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6012208.34529 | 2107668.53767 | 37.7679437428368 | -122.401049131921 | (37.7679437428368, -122.401049131921) | 14 | 3 | 8 | 28856 | 20 | |||
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 | |||
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 | |
184446 | 192406 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 718 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | 10 | 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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
157151 | 67546 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1139 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 19 | Permit Number 31092 | 6011964.43282 | 2103102.09088 | 37.7553916864972 | -122.401571818805 | (37.7553916864972, -122.401571818805) | 10 | 3 | 8 | 28856 | 29 | |
95128 | 67495 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1126 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 18 | Permit Number 31020 | 6011901.71261 | 2103178.79248 | 37.7555987922788 | -122.401794116823 | (37.7555987922788, -122.401794116823) | 10 | 3 | 8 | 28856 | 29 | |
127888 | 67548 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1120 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 16 | Permit Number 31094 | 6011900.0943 | 2103205.59495 | 37.7556722956615 | -122.401801597389 | (37.7556722956615, -122.401801597389) | 10 | 3 | 8 | 28856 | 29 | |
94859 | 192414 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.7604149289253 | -122.402245819308 | (37.7604149289253, -122.402245819308) | 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 | ||
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 | |||
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 | |
128657 | 192413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 5 | : | Tree | Private 2 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | 10 | 3 | 8 | 28856 | 29 | |||
103330 | 192412 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.7615038424566 | -122.402363116082 | (37.7615038424566, -122.402363116082) | 10 | 3 | 8 | 28856 | 29 | |||
98073 | 192411 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.402369426605 | (37.7615462436837, -122.402369426605) | 10 | 3 | 8 | 28856 | 29 | |||
172851 | 192410 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6011779.10813 | 2105360.6424 | 37.7615828263046 | -122.402371529224 | (37.7615828263046, -122.402371529224) | 10 | 3 | 8 | 28856 | 29 | |||
110175 | 192409 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
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 | |||
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 | |
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 | |||
73497 | 192408 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 799 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011594.92882 | 2104699.39002 | 37.7597568913958 | -122.4029620232 | (37.7597568913958, -122.4029620232) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
74085 | 78433 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2016 12:00:00 AM | 3 | 6011558.92592 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | 10 | 3 | 8 | 28856 | 29 | ||
178250 | 192407 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 862 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011557.46585 | 2104307.68727 | 37.758679270636 | -122.403064037781 | (37.758679270636, -122.403064037781) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
17037 | 264800 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 330 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011202 | 2089015 | 37.7166689455126 | -122.403217660421 | (37.7166689455126, -122.403217660421) | 10 | 7 | 8 | 309 | 39 | ||||
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 | |||
15542 | 262169 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 111 Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010514.3033 | 2087552.92261 | 37.7126159475575 | -122.405491784734 | (37.7126159475575, -122.405491784734) | 9 | 7 | 8 | 309 | 39 | ||
117463 | 95134 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 450@ Wayland Somerset St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781342 | 6010117.36612 | 2092259.39432 | 37.7255167458877 | -122.407195288535 | (37.7255167458877, -122.407195288535) | 10 | 3 | 7 | 309 | 28 |
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) );