trees
508 rows where qSpecies_id = 25 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 192943 | 59914 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 409 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1981 12:00:00 AM | 12 | Permit Number 19383 | 5999728.7839 | 2110019.0941 | 37.773693712339 | -122.444383331369 | (37.773693712339, -122.444383331369) | 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 | ||
| 192021 | 93025 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005372 | 2101391 | 37.7503233669919 | -122.424248785816 | (37.7503233669919, -122.424248785816) | 2 | 4 | 5 | 28859 | 19 | |||||
| 191506 | 59773 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 136 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 19218 | 6007237.20914714 | 2096749.07204327 | 37.7376828142423 | -122.417469811222 | (37.7376828142423, -122.417469811222) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |
| 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 | |||
| 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 | |||
| 187975 | 59935 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1743 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 12 | Permit Number 19408 | 5999522.2814 | 2110138.642 | 37.7740101761611 | -122.445106249319 | (37.7740101761611, -122.445106249319) | 15 | 5 | 11 | 29492 | 16 | |
| 187856 | 225937 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008665.07635 | 2101351.07554 | 37.7503991370286 | -122.412858243028 | (37.7503991370286, -122.412858243028) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 186906 | 10133 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005711.897824 | 2103735.5027185 | 37.7567800151629 | -122.423240032254 | (37.7567800151629, -122.423240032254) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | |
| 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 | |||
| 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 | |
| 185874 | 35568 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 25 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38937 | 6006180.09920883 | 2103440.54844158 | 37.7559965511416 | -122.421599868894 | (37.7559965511416, -122.421599868894) | 2 | 4 | 5 | 28859 | 19 | ||
| 185751 | 225975 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 4337 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001561.54822 | 2104657.76141 | 37.7590772134726 | -122.437659488305 | (37.7590772134726, -122.437659488305) | 2 | 4 | 5 | 28862 | 3 | |||
| 185087 | 69160 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | Permit Number 33197 | 6007895.60997349 | 2101540.97783702 | 37.7508773450466 | -122.415532563624 | (37.7508773450466, -122.415532563624) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | ||||
| 183813 | 219000 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |
| 182243 | 32109 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 431 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002988.87793 | 2105732.43045 | 37.7621090484283 | -122.432799880203 | (37.7621090484283, -122.432799880203) | 15 | 4 | 5 | 28862 | 3 | |
| 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 | |||
| 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 | ||||
| 181241 | 10001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.7687236538132 | -122.424371552702 | (37.7687236538132, -122.424371552702) | 8 | 4 | 5 | 28853 | 19 | |||
| 180699 | 225958 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006997.29883 | 2096792.90464 | 37.7377896670691 | -122.418302405036 | (37.7377896670691, -122.418302405036) | 2 | 7 | 7 | 28859 | 2 | |||
| 180610 | 219003 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993948.08517 | 2105555.37526 | 37.7611059976579 | -122.464055414128 | (37.7611059976579, -122.464055414128) | 1 | 5 | 11 | 56 | 12 | |||
| 180292 | 217005 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3x12 | Permit Number 782164 | 5991273.49549 | 2097061.96197 | 37.737630785637 | -122.472686293253 | (37.737630785637, -122.472686293253) | 1 | 8 | 4 | 29491 | 40 | |
| 179902 | 30918 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 Granada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941 | -122.457074050715 | (37.722170938941, -122.457074050715) | 9 | 8 | 4 | 28861 | 24 | |||
| 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 | |||
| 179525 | 225910 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.424252263031 | (37.7553044666341, -122.424252263031) | 2 | 4 | 5 | 28859 | 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 |
| 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 | |||
| 179106 | 10227 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6005821.31625 | 2100751.57346 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) | 2 | 4 | 5 | 28859 | 19 | |||
| 178381 | 254173 | Significant Tree 6 | Geijera parviflora :: Australian Willow 25 | 1850 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x6 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | ||||
| 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 | |||
| 177781 | 26513 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6008948.96043 | 2101783.08136 | 37.7516012590109 | -122.411907072357 | (37.7516012590109, -122.411907072357) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 177469 | 46928 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | ||
| 176770 | 10132 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005714.0796 | 2103814.39751 | 37.756996764997 | -122.423238094856 | (37.756996764997, -122.423238094856) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | |||
| 174260 | 75710 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1190 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1993 12:00:00 AM | 12 | 18x3 | 6008645.48606603 | 2101619.0486747 | 37.7511338315754 | -122.412944932355 | (37.7511338315754, -122.412944932355) | 2 | 4 | 7 | 28859 | 19 | ||
| 173884 | 225964 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007927.65948 | 2096983.88773 | 37.7383663914855 | -122.415099202478 | (37.7383663914855, -122.415099202478) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 173191 | 225928 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1106 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998173.76607 | 2106499.88804 | 37.7639420241322 | -122.449508728942 | (37.7639420241322, -122.449508728942) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | ||||
| 172579 | 116342 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 611 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778005 | 6009887 | 2105445 | 37.7617086481783 | -122.408921539166 | (37.7617086481783, -122.408921539166) | 2 | 4 | 8 | 28859 | 19 | |
| 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 | |||
| 171972 | 115822 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
| 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 | |
| 171069 | 225938 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008664.0646 | 2101365.80196 | 37.7504395156908 | -122.412862782791 | (37.7504395156908, -122.412862782791) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 168934 | 95169 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 195x BARTLETT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 54079 | 6006751 | 2102668 | 37.7539074858503 | -122.419570691657 | (37.7539074858503, -122.419570691657) | 2 | 4 | 7 | 28859 | 19 | |||
| 167735 | 68770 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32698 | 6002993.73826974 | 2104676.98539815 | 37.7592113259791 | -122.432707672319 | (37.7592113259791, -122.432707672319) | 2 | 4 | 5 | 28862 | 3 | ||
| 167519 | 225923 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1523 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009609.76682 | 2100372.84408 | 37.7477661109153 | -122.409522389545 | (37.7477661109153, -122.409522389545) | 2 | 7 | 7 | 28859 | 2 | |||
| 166911 | 94129 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 420 Holladay Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53495 | 6010221.9 | 2098587.9 | 37.7428993246027 | -122.407279845082 | (37.7428993246027, -122.407279845082) | 10 | 7 | 7 | 28859 | 2 | ||
| 166847 | 219013 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995360.70731 | 2090920.75617 | 37.721004266213 | -122.458110615707 | (37.721004266213, -122.458110615707) | 9 | 8 | 6 | 28861 | 24 | |||
| 166681 | 98259 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008057 | 2106814 | 37.7653649274264 | -122.415347709739 | (37.7653649274264, -122.415347709739) | 8 | 4 | 7 | 28853 | 19 | |||
| 165944 | 37469 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39940 | 6009863.21581356 | 2098931.68283254 | 37.7438231962188 | -122.408544326388 | (37.7438231962188, -122.408544326388) | 2 | 7 | 7 | 28859 | 2 | ||
| 165638 | 219006 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 221 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995326.92312 | 2091423.08508 | 37.7223816004164 | -122.458263736089 | (37.7223816004164, -122.458263736089) | 9 | 8 | 4 | 28861 | 24 | |||
| 165441 | 225920 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 300 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009736.52173 | 2099618.93286 | 37.7457031381078 | -122.409030888471 | (37.7457031381078, -122.409030888471) | 2 | 7 | 7 | 28859 | 2 | |||
| 165063 | 67769 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3668 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31399 | 6002481.45062456 | 2106510.50272194 | 37.7642166536125 | -122.434610512105 | (37.7642166536125, -122.434610512105) | 15 | 5 | 5 | 28862 | 3 | ||
| 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 | |
| 164760 | 35153 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38684 | 6003946.04415605 | 2109759.28063083 | 37.7732200439593 | -122.429776640335 | (37.7732200439593, -122.429776640335) | 7 | 9 | 11 | 29492 | 10 | ||
| 164529 | 60139 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1825 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19669 | 5991215.5539121 | 2102985.82371421 | 37.7538928250767 | -122.473318554461 | (37.7538928250767, -122.473318554461) | 1 | 8 | 4 | 56 | 12 | ||
| 164299 | 176500 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 162 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005731.33862 | 2087429.69303 | 37.712008985404 | -122.422014487205 | (37.712008985404, -122.422014487205) | 9 | 7 | 8 | 309 | 18 | |||
| 164183 | 176512 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006244.01324 | 2087410.04073 | 37.711983925792 | -122.420241140118 | (37.711983925792, -122.420241140118) | 9 | 7 | 8 | 309 | 39 | |||
| 164054 | 67684 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | 3.5x6 | Permit Number 31288 | 6000001.77226965 | 2094984.07917219 | 37.7324267912213 | -122.442359437007 | (37.7324267912213, -122.442359437007) | 9 | 7 | 4 | 63 | 40 | ||
| 163091 | 35092 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1998 12:00:00 AM | 25 | 3x3 | Permit Number 38633 | 5992055.93239281 | 2105259.4330846 | 37.7601841866451 | -122.470577939927 | (37.7601841866451, -122.470577939927) | 1 | 8 | 4 | 56 | 12 | |
| 162728 | 46929 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
| 161550 | 105214 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
| 161331 | 219010 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995318.05663 | 2090927.82531 | 37.7210212256375 | -122.458258556898 | (37.7210212256375, -122.458258556898) | 9 | 8 | 6 | 28861 | 24 | |||
| 161230 | 98178 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 44- 46 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005746 | 2106381 | 37.7640458540826 | -122.423310148397 | (37.7640458540826, -122.423310148397) | 8 | 4 | 5 | 28859 | 19 | ||||
| 160924 | 225903 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 50 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005652.74783 | 2106381.31475 | 37.7640414549602 | -122.423632703012 | (37.7640414549602, -122.423632703012) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 160588 | 225907 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3749 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005583.06138 | 2101365.98068 | 37.7502665850353 | -122.423517141925 | (37.7502665850353, -122.423517141925) | 2 | 4 | 5 | 28859 | 19 | |||
| 160376 | 225936 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008666.40255 | 2101335.68894 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | 2 | 4 | 7 | 28859 | 19 | |||
| 160188 | 46336 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3458 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44586 | 6006755.84747481 | 2100893.1278825 | 37.7490343653145 | -122.419428021305 | (37.7490343653145, -122.419428021305) | 2 | 4 | 7 | 28859 | 19 | ||
| 159651 | 46927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
| 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 | |
| 157767 | 10076 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2x2 | 6005555.84644 | 2105437.30746 | 37.7614439637781 | -122.423900725242 | (37.7614439637781, -122.423900725242) | 2 | 4 | 5 | 28859 | 19 | |||
| 157154 | 57311 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 50- 60 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | Permit Number 16134 | 6005724.56470965 | 2106391.56239992 | 37.764073646158 | -122.423385037786 | (37.764073646158, -122.423385037786) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |
| 157138 | 176504 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005618.83947 | 2087124.32667 | 37.711164168567 | -122.422381633625 | (37.711164168567, -122.422381633625) | 9 | 7 | 8 | 309 | 18 | |||
| 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 | |
| 155738 | 176507 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | 9 | 7 | 8 | 309 | 39 | |||
| 155414 | 35576 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38944 | 6005785.83921356 | 2104003.6408016 | 37.7575204324701 | -122.42300337284 | (37.7575204324701, -122.42300337284) | 2 | 4 | 5 | 28859 | 19 | ||
| 155371 | 225951 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000607.24532 | 2101675.70073 | 37.7508348927316 | -122.440746005644 | (37.7508348927316, -122.440746005644) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 154480 | 225954 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003654.86904 | 2095911.56632 | 37.7351809981922 | -122.429795956641 | (37.7351809981922, -122.429795956641) | 2 | 7 | 5 | 63 | 7 | |||
| 153977 | 49768 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46559 | 6008671.05987 | 2086426.1944 | 37.7094189460104 | -122.411783070238 | (37.7094189460104, -122.411783070238) | 9 | 7 | 8 | 309 | 39 | |
| 153413 | 10054 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 426 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X2 | 6005501.95571 | 2106458.62904 | 37.764245228771 | -122.424159747992 | (37.764245228771, -122.424159747992) | 8 | 4 | 5 | 28859 | 19 | |||
| 153039 | 225961 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 202 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007991.11967 | 2096976.87427 | 37.7383507001153 | -122.414879291246 | (37.7383507001153, -122.414879291246) | 2 | 7 | 7 | 28859 | 2 | |||
| 152965 | 59772 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 131 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1981 12:00:00 AM | Permit Number 19217 | 6007221.04974766 | 2096803.89603525 | 37.7378324395755 | -122.417529566585 | (37.7378324395755, -122.417529566585) | 2 | 7 | 7 | 28859 | 2 | ||
| 151974 | 36066 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 151826 | 255813 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782164 | 5991340.67425 | 2097062.85197 | 37.7376371178542 | -122.472454091358 | (37.7376371178542, -122.472454091358) | 1 | 8 | 4 | 29491 | 40 | |
| 151060 | 59771 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30471 | 6006914.85070557 | 2096794.9528113 | 37.7377906494843 | -122.41858761398 | (37.7377906494843, -122.41858761398) | 2 | 7 | 7 | 28859 | 2 | ||
| 149538 | 42034 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50466 | 6004260 | 2098933 | 37.7435114157111 | -122.427919028307 | (37.7435114157111, -122.427919028307) | 2 | 7 | 5 | 63 | 22 |
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) );