trees
614 rows where qSpecies_id = 29 sorted by Zip Codes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26259 | 217579 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.7143464128453 | -122.468610110073 | (37.7143464128453, -122.468610110073) | 9 | 8 | 6 | 64 | 24 | |||
| 30874 | 18608 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | 9 | 8 | 6 | 64 | 24 | ||
| 48198 | 18596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.466428817805 | (37.7141961040887, -122.466428817805) | 9 | 8 | 6 | 64 | 24 | ||
| 67115 | 25468 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 437 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992774.4094 | 2088493.0908 | 37.7141895393891 | -122.466874212626 | (37.7141895393891, -122.466874212626) | 9 | 8 | 6 | 64 | 24 | ||
| 76954 | 214036 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 262 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992219.26388 | 2089623.39625 | 37.7172610279406 | -122.46887519663 | (37.7172610279406, -122.46887519663) | 9 | 8 | 6 | 64 | 24 | |||
| 105034 | 48566 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 638 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45985 | 5993535.88564574 | 2090091.48019383 | 37.7186222534444 | -122.464358255955 | (37.7186222534444, -122.464358255955) | 9 | 8 | 6 | 64 | 24 | ||
| 111539 | 217581 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 500 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992611.7697 | 2088555.8456 | 37.7143524607031 | -122.467440914144 | (37.7143524607031, -122.467440914144) | 9 | 8 | 6 | 64 | 24 | |||
| 123102 | 87075 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 395 Byxbee St | 6 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 124526 | 214037 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5993017.24879 | 2090566.81293 | 37.7198974930477 | -122.466185481793 | (37.7198974930477, -122.466185481793) | 9 | 8 | 6 | 64 | 24 | |||
| 130716 | 18607 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | 9 | 8 | 6 | 64 | 24 | ||
| 132873 | 25463 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 308 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | 3 | 3X3 | 5993157.11936 | 2088546.32287 | 37.7143577829742 | -122.46555529463 | (37.7143577829742, -122.46555529463) | 9 | 8 | 6 | 64 | 24 | ||
| 133862 | 214038 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 638 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45985 | 5993525.36191 | 2090091.06114 | 37.7186204962068 | -122.464394601529 | (37.7186204962068, -122.464394601529) | 9 | 8 | 6 | 64 | 24 | |
| 140741 | 18570 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 698X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 5992368.0058464 | 2088553.4079402 | 37.7143316913291 | -122.468283273537 | (37.7143316913291, -122.468283273537) | 9 | 8 | 6 | 64 | 24 | ||
| 141663 | 87074 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 395 Byxbee St | 5 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 143532 | 18603 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | 9 | 8 | 6 | 64 | 24 | ||
| 155055 | 17244 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 10X Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 6 | 3X3 | 5993945.3779 | 2088542.9193 | 37.7143938707274 | -122.462830535838 | (37.7143938707274, -122.462830535838) | 9 | 8 | 6 | 64 | 24 | ||
| 156793 | 217578 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 308 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5993138.4427 | 2088550.8537 | 37.7143691463099 | -122.465620176978 | (37.7143691463099, -122.465620176978) | 9 | 8 | 6 | 64 | 24 | |||
| 8833 | 240424 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 6 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.433987315365 | (37.7363966594644, -122.433987315365) | 2 | 7 | 5 | 63 | 7 | |||
| 15621 | 68830 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32781 | 6000000.33338592 | 2094041.19205625 | 37.7298377607142 | -122.442296747396 | (37.7298377607142, -122.442296747396) | 9 | 7 | 4 | 63 | 40 | ||
| 21743 | 9330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.5022559 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | 2 | 7 | 5 | 63 | 7 | ||
| 21889 | 240418 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001776.14511 | 2096508.83113 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | 2 | 7 | 5 | 63 | 7 | |||
| 26882 | 37419 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39897 | 6002931.14322816 | 2099749.14332352 | 37.7456770883652 | -122.432572163971 | (37.7456770883652, -122.432572163971) | 2 | 7 | 5 | 63 | 22 | ||
| 27508 | 68856 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32819 | 6000663.76465174 | 2094326.91833664 | 37.7306600888757 | -122.440023675014 | (37.7306600888757, -122.440023675014) | 9 | 7 | 4 | 63 | 40 | ||
| 29514 | 214024 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000768.15588 | 2094464.11739 | 37.7310427480136 | -122.439672611702 | (37.7310427480136, -122.439672611702) | 9 | 7 | 4 | 63 | 40 | |||
| 30544 | 41593 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 538 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43228 | 6003084.80949648 | 2098934.42438565 | 37.7434487728436 | -122.431982642828 | (37.7434487728436, -122.431982642828) | 2 | 7 | 5 | 63 | 22 | ||
| 31447 | 240421 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002440.89213 | 2096392.57557 | 37.7364329192297 | -122.434027483591 | (37.7364329192297, -122.434027483591) | 2 | 7 | 5 | 63 | 7 | |||
| 35359 | 94659 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765 | 2094447 | 37.7309955679913 | -122.439682295377 | (37.7309955679913, -122.439682295377) | 9 | 7 | 4 | 63 | 40 |
| 36649 | 43585 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 237 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43246 | 6004367.379779 | 2099245.61051184 | 37.7443758465625 | -122.427570002743 | (37.7443758465625, -122.427570002743) | 2 | 7 | 5 | 63 | 22 | ||
| 49906 | 41694 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42146 | 6003561.9148943 | 2096429.88916823 | 37.7365989305362 | -122.430154297904 | (37.7365989305362, -122.430154297904) | 2 | 7 | 5 | 63 | 7 | ||
| 52155 | 94656 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765 | 2094410 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) | 9 | 7 | 4 | 63 | 40 |
| 55782 | 47698 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 297 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458918 | 37.7322859754961 | -122.441914392194 | (37.7322859754961, -122.441914392194) | 9 | 7 | 4 | 63 | 40 | ||
| 58215 | 240423 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 5 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002449.92079 | 2096381.92143 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | 2 | 7 | 5 | 63 | 7 | |||
| 59685 | 41706 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42155 | 6001936.91803675 | 2096162.95952183 | 37.7357738321427 | -122.435753508421 | (37.7357738321427, -122.435753508421) | 2 | 7 | 5 | 63 | 7 | ||
| 60862 | 240422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 4 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.434020937432 | (37.7364241292793, -122.434020937432) | 2 | 7 | 5 | 63 | 7 | |||
| 61566 | 214027 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | 9 | 7 | 4 | 63 | 40 | |||
| 64803 | 214023 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000598.84895 | 2094335.44716 | 37.7306798113107 | -122.440248709336 | (37.7306798113107, -122.440248709336) | 9 | 7 | 4 | 63 | 40 | |||
| 66488 | 41690 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107594 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | 2 | 7 | 5 | 63 | 7 | ||
| 67662 | 240398 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002001.74432 | 2099212.54095 | 37.7441509550044 | -122.435747497273 | (37.7441509550044, -122.435747497273) | 2 | 7 | 5 | 63 | 22 | |||
| 70017 | 240417 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001765.76464 | 2096530.83358 | 37.7367742056673 | -122.436371571893 | (37.7367742056673, -122.436371571893) | 2 | 7 | 5 | 63 | 7 | |||
| 72495 | 214040 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999932.25708 | 2094051.5429 | 37.729862301496 | -122.442532837136 | (37.729862301496, -122.442532837136) | 9 | 7 | 4 | 63 | 40 | |||
| 76531 | 41700 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 135 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42150 | 6002619.11270974 | 2096812.53264581 | 37.7375961375204 | -122.433441302095 | (37.7375961375204, -122.433441302095) | 2 | 7 | 5 | 63 | 7 | ||
| 79265 | 240420 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001790.09859 | 2096478.24715 | 37.7366311981596 | -122.436283676644 | (37.7366311981596, -122.436283676644) | 2 | 7 | 5 | 63 | 7 | |||
| 80016 | 240399 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002005.77197 | 2099212.90242 | 37.7441521762959 | -122.435733596422 | (37.7441521762959, -122.435733596422) | 2 | 7 | 5 | 63 | 22 | |||
| 81022 | 102592 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 124 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765 | 2094428 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | 9 | 7 | 4 | 63 | 40 | |
| 82279 | 47718 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45513 | 6003399.03676128 | 2096258.54340471 | 37.7361192276447 | -122.430705213698 | (37.7361192276447, -122.430705213698) | 2 | 7 | 5 | 63 | 7 | ||
| 85562 | 86997 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 248 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49939 | 6004323 | 2098701 | 37.7428779608266 | -122.42768466378 | (37.7428779608266, -122.42768466378) | 2 | 7 | 5 | 63 | 22 | ||
| 90484 | 214026 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 124 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.439646720232 | (37.7311480595383, -122.439646720232) | 9 | 7 | 4 | 63 | 40 | |||
| 92008 | 94657 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765 | 2094410 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) | 9 | 7 | 4 | 63 | 40 |
| 97817 | 240394 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 27 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001499.24152 | 2098615.40839 | 37.742482813337 | -122.437442286753 | (37.742482813337, -122.437442286753) | 2 | 7 | 5 | 63 | 7 | |||
| 98469 | 22550 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 23 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2008 12:00:00 AM | 4 | 2x3 | 6001475.7294271 | 2098645.6307199 | 37.7425644600069 | -122.437525748228 | (37.7425644600069, -122.437525748228) | 2 | 7 | 5 | 63 | 7 | ||
| 100145 | 240416 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 12 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003644.58951 | 2098299.35585 | 37.7417367402568 | -122.430001772769 | (37.7417367402568, -122.430001772769) | 2 | 7 | 5 | 63 | 7 | |||
| 105290 | 240410 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.435840244336 | (37.735834211766, -122.435840244336) | 2 | 7 | 5 | 63 | 7 | |||
| 110093 | 240405 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003457.25772 | 2096114.18055 | 37.7357261384478 | -122.430493622802 | (37.7357261384478, -122.430493622802) | 2 | 7 | 5 | 63 | 7 | |||
| 114385 | 102595 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769795 | 6000714.8 | 2094523.9 | 37.7312038601891 | -122.439861356334 | (37.7312038601891, -122.439861356334) | 9 | 7 | 4 | 63 | 40 |
| 115726 | 240411 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 235 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001924.04211 | 2096180.04982 | 37.7358200267578 | -122.435799247861 | (37.7358200267578, -122.435799247861) | 2 | 7 | 5 | 63 | 7 | |||
| 118824 | 94658 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765 | 2094447 | 37.7309955679913 | -122.439682295377 | (37.7309955679913, -122.439682295377) | 9 | 7 | 4 | 63 | 40 |
| 148078 | 66617 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 29820 | 6003370.78769204 | 2095896.23030716 | 37.7351227979483 | -122.430777034501 | (37.7351227979483, -122.430777034501) | 2 | 7 | 5 | 63 | 7 | ||
| 148602 | 240419 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001783.7465 | 2096493.52621 | 37.7366727900018 | -122.436306731665 | (37.7366727900018, -122.436306731665) | 2 | 7 | 5 | 63 | 7 | |||
| 148880 | 240407 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | 2 | 7 | 5 | 63 | 7 | |||
| 152553 | 240408 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 180 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001780.1737 | 2096439.35558 | 37.7365238469964 | -122.436315208675 | (37.7365238469964, -122.436315208675) | 2 | 7 | 5 | 63 | 7 | |||
| 152659 | 47699 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 297 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458918 | 37.7322859754961 | -122.441914392194 | (37.7322859754961, -122.441914392194) | 9 | 7 | 4 | 63 | 40 | |||
| 164354 | 240409 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002196.79726 | 2096967.09193 | 37.7379965524899 | -122.434912495609 | (37.7379965524899, -122.434912495609) | 2 | 7 | 5 | 63 | 7 | |||
| 168828 | 240425 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 7 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002456.87513 | 2096374.31689 | 37.7363836921523 | -122.433970918943 | (37.7363836921523, -122.433970918943) | 2 | 7 | 5 | 63 | 7 | |||
| 169888 | 240403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.432572903928 | (37.7457049727185, -122.432572903928) | 2 | 7 | 5 | 63 | 22 | |||
| 177533 | 214039 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6000414.26094 | 2095519.56512 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | 9 | 7 | 5 | 63 | 40 | |||
| 182264 | 240397 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6001997.9354 | 2099211.95257 | 37.7441491230941 | -122.435760625573 | (37.7441491230941, -122.435760625573) | 2 | 7 | 5 | 63 | 22 | |||
| 190336 | 240406 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003419.55137 | 2096211.39701 | 37.7359909366181 | -122.430630923178 | (37.7359909366181, -122.430630923178) | 2 | 7 | 5 | 63 | 7 | |||
| 190732 | 253817 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001018 | 2098627 | 37.7424872697547 | -122.439107103686 | (37.7424872697547, -122.439107103686) | 2 | 7 | 5 | 63 | 7 | ||||
| 191033 | 34936 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 11 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1997 12:00:00 AM | Permit Number 38531 | 6004292.24994663 | 2098281.86304207 | 37.7417253672991 | -122.427761131369 | (37.7417253672991, -122.427761131369) | 2 | 7 | 5 | 63 | 7 | |||
| 191500 | 41691 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107594 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | 2 | 7 | 5 | 63 | 7 | |||
| 192565 | 214025 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000768.8435 | 2094480.08399 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | 9 | 7 | 4 | 63 | 40 | |||
| 192970 | 214028 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6000768.83365 | 2094531.22311 | 37.7312270433827 | -122.439675077642 | (37.7312270433827, -122.439675077642) | 9 | 7 | 4 | 63 | 40 | |||
| 50270 | 40783 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
| 61612 | 40785 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
| 64020 | 47995 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2594 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | 1 | 8 | 4 | 59 | 40 | |
| 76457 | 40784 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
| 89675 | 23598 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200X Vasquez Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
| 97806 | 207057 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991827.84816 | 2097768.26997 | 37.7396022020835 | -122.470821084031 | (37.7396022020835, -122.470821084031) | 1 | 8 | 4 | 59 | 40 | |||
| 99470 | 38034 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | 1 | 8 | 4 | 59 | 40 | ||
| 124070 | 214021 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 75 Fairfield Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993799.03412 | 2093427.92907 | 37.7277984986013 | -122.463690690492 | (37.7277984986013, -122.463690690492) | 9 | 8 | 4 | 59 | 40 | |||
| 142099 | 23599 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200X Vasquez Ave | 9 | Median : Cutout | Tree | DPW 1 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
| 143115 | 214020 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 75 Fairfield Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993790.82197 | 2093445.17793 | 37.7278453865466 | -122.463720331235 | (37.7278453865466, -122.463720331235) | 9 | 8 | 4 | 59 | 40 | |||
| 149625 | 93721 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.7386518615207 | -122.467087971441 | (37.7386518615207, -122.467087971441) | 1 | 8 | 4 | 59 | 40 | ||
| 152064 | 40786 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
| 156868 | 47994 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2594 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | 1 | 8 | 4 | 59 | 40 | |
| 161935 | 207056 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 340 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991811.94775 | 2097766.11202 | 37.7395953573424 | -122.470875903123 | (37.7395953573424, -122.470875903123) | 1 | 8 | 4 | 59 | 40 | |||
| 178410 | 93722 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1434 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.7386518615207 | -122.467087971441 | (37.7386518615207, -122.467087971441) | 1 | 8 | 4 | 59 | 40 | ||
| 181144 | 13408 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 364 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
| 6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
| 13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
| 16909 | 38635 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 33 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
| 31760 | 53143 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1498@ KEITH Underwood Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
| 35846 | 113422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | 10 | 3 | 8 | 58 | 1 | ||
| 58083 | 201725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1915 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6013561.8417 | 2095888.78027 | 37.7356744661038 | -122.395542109982 | (37.7356744661038, -122.395542109982) | 10 | 3 | 8 | 58 | 1 | ||||
| 58114 | 197341 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | 10 | 3 | 8 | 58 | 1 | ||||
| 65254 | 40032 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | 10 | 3 | 8 | 58 | 1 | ||
| 68406 | 38637 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2010 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
| 70662 | 35869 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.405617981988 | (37.7381266097475, -122.405617981988) | 10 | 3 | 8 | 58 | 1 | |
| 80778 | 200055 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014871.4407 | 2094140.9637 | 37.7309480732984 | -122.390892168964 | (37.7309480732984, -122.390892168964) | 10 | 3 | 8 | 58 | 1 | |||
| 89232 | 40031 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | 10 | 3 | 8 | 58 | 1 |
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) );