trees
368 rows where qSpecies_id = 144 sorted by Police Districts
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123953 | 249936 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 339 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011252.89025 | 2120033.51867 | 37.8018417214754 | -122.405224787598 | (37.8018417214754, -122.405224787598) | 3 | 1 | 10 | 308 | 23 | |||
| 835 | 61682 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 27 Ceres St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 4 | Permit Number 21679 | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | |
| 961 | 76397 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6016633.05444 | 2099489.61531 | 37.7457319802501 | -122.38517445926 | (37.7457319802501, -122.38517445926) | 10 | 3 | 8 | 58 | 1 | |||
| 4179 | 76360 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016677.69743 | 2099491.25427 | 37.7457389499883 | -122.385020203019 | (37.7457389499883, -122.385020203019) | 10 | 3 | 8 | 58 | 1 | |||
| 12371 | 76341 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6016694.6962 | 2099491.47617 | 37.7457404995381 | -122.384961438646 | (37.7457404995381, -122.384961438646) | 10 | 3 | 8 | 58 | 1 | |||
| 19518 | 191049 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6016661.68258 | 2099490.66048 | 37.7457364337019 | -122.385075539199 | (37.7457364337019, -122.385075539199) | 10 | 3 | 8 | 58 | 1 | |||
| 27622 | 103900 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 29343 | 176202 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 746 Olmstead St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6009489.79963 | 2090597.27291 | 37.7209177667302 | -122.409247502765 | (37.7209177667302, -122.409247502765) | 9 | 3 | 7 | 309 | 28 | |||
| 30795 | 201990 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013571.20054 | 2092301.57484 | 37.7258252538048 | -122.395258547459 | (37.7258252538048, -122.395258547459) | 10 | 3 | 8 | 58 | 1 | ||||
| 38920 | 103903 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 39002 | 103913 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 41756 | 191040 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 35 | Front Yard : Yard | Tree | Private 2 | 15 | 6015380.38588 | 2102504.53618 | 37.7539409451402 | -122.389716581452 | (37.7539409451402, -122.389716581452) | 10 | 3 | 8 | 28856 | 29 | ||||
| 52981 | 103904 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 54103 | 42743 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 295 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42737 | 6012647.1314 | 2087116.87515 | 37.7115376741026 | -122.398089440585 | (37.7115376741026, -122.398089440585) | 10 | 3 | 8 | 309 | 1 | ||
| 54449 | 191043 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 38 | Front Yard : Yard | Tree | Private 2 | 16 | 6015378.95321 | 2102517.91252 | 37.7539775942935 | -122.389722470218 | (37.7539775942935, -122.389722470218) | 10 | 3 | 8 | 28856 | 29 | ||||
| 54577 | 191045 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 900x Carolina St | 40 | Median : Yard | Tree | DPW 1 | 7 | 6012497.15794 | 2103097.51934 | 37.7554088455429 | -122.399729160991 | (37.7554088455429, -122.399729160991) | 10 | 3 | 8 | 28856 | 29 | ||||
| 60417 | 191042 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 37 | Front Yard : Yard | Tree | Private 2 | 6 | 6015379.59979 | 2102513.14016 | 37.7539645262576 | -122.389719900867 | (37.7539645262576, -122.389719900867) | 10 | 3 | 8 | 28856 | 29 | ||||
| 61560 | 103905 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 62716 | 176212 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 643 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009383.55707 | 2092917.45205 | 37.7272825386525 | -122.409778442743 | (37.7272825386525, -122.409778442743) | 10 | 3 | 7 | 309 | 28 | |||
| 66250 | 103906 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 68566 | 191038 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 17 | Front Yard : Yard | Tree | Private 2 | 7 | 6015383.3127 | 2102378.63663 | 37.7535954139151 | -122.38969766693 | (37.7535954139151, -122.38969766693) | 10 | 3 | 8 | 28856 | 29 | ||||
| 69906 | 67487 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1715 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 3 | Permit Number 31011 | 6012862.87074 | 2104700.41126 | 37.7598304163533 | -122.398576880337 | (37.7598304163533, -122.398576880337) | 10 | 3 | 8 | 28856 | 29 | |
| 70611 | 35481 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1011 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1998 12:00:00 AM | 9 | Permit Number 38892 | 6007771.76175 | 2093386.17164 | 37.7284790839175 | -122.415383596892 | (37.7284790839175, -122.415383596892) | 9 | 3 | 7 | 309 | 5 | ||
| 72752 | 201988 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013586.6338 | 2092298.57883 | 37.7258178856713 | -122.39520498563 | (37.7258178856713, -122.39520498563) | 10 | 3 | 8 | 58 | 1 | ||||
| 72876 | 187592 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6010726.84858 | 2091332.925 | 37.7230069439869 | -122.405023145203 | (37.7230069439869, -122.405023145203) | 10 | 3 | 7 | 309 | 28 | ||||
| 79281 | 38192 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 715 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 6 | Permit Number 40321 | 6011331.34824 | 2091527.76082 | 37.7235756968497 | -122.40294719786 | (37.7235756968497, -122.40294719786) | 10 | 3 | 7 | 309 | 28 | |
| 80703 | 176199 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 800 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6011139.2917 | 2091015.07876 | 37.7221572510345 | -122.403575053247 | (37.7221572510345, -122.403575053247) | 10 | 3 | 7 | 309 | 28 | |||
| 88044 | 191046 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 900x Carolina St | 44 | Median : Yard | Tree | DPW 1 | 6 | 6012503.19406 | 2103068.83729 | 37.7553304273806 | -122.399706272322 | (37.7553304273806, -122.399706272322) | 10 | 3 | 8 | 28856 | 29 | ||||
| 92875 | 103911 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 92980 | 50307 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 755 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 6 | Permit Number 47018 | 6012755.49383 | 2104002.55412 | 37.7579082710796 | -122.398899267499 | (37.7579082710796, -122.398899267499) | 10 | 3 | 8 | 28856 | 29 | ||
| 93161 | 103910 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 97048 | 103902 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 98316 | 176201 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 746 Olmstead St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6009499.02915 | 2090599.59902 | 37.7209246708253 | -122.409215763009 | (37.7209246708253, -122.409215763009) | 9 | 3 | 7 | 309 | 28 | |||
| 103322 | 191047 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 508 Missouri St | 3 | : | Tree | Private 2 | 5 | Width 8ft | 6013509.00195 | 2104632.60387 | 37.7596802080014 | -122.396337460525 | (37.7596802080014, -122.396337460525) | 10 | 3 | 8 | 28856 | 29 | |||
| 107833 | 176203 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 746 Olmstead St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6009481.93286 | 2090594.23315 | 37.7209089794419 | -122.409274481543 | (37.7209089794419, -122.409274481543) | 9 | 3 | 7 | 309 | 28 | |||
| 112229 | 201986 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013604.03863 | 2092295.50097 | 37.7258104024118 | -122.395144602456 | (37.7258104024118, -122.395144602456) | 10 | 3 | 8 | 58 | 1 | |||
| 128104 | 191041 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 36 | Front Yard : Yard | Tree | Private 2 | 10 | 6015379.60354 | 2102508.57435 | 37.7539519897179 | -122.38971956902 | (37.7539519897179, -122.38971956902) | 10 | 3 | 8 | 28856 | 29 | ||||
| 140444 | 191050 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1980 Revere Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6013083.07129 | 2095907.79481 | 37.7357000338279 | -122.397198748442 | (37.7357000338279, -122.397198748442) | 10 | 3 | 8 | 58 | 1 | ||||
| 141884 | 187593 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6010735.28382 | 2091330.7832 | 37.7230015345836 | -122.40499383541 | (37.7230015345836, -122.40499383541) | 10 | 3 | 7 | 309 | 28 | ||||
| 144109 | 50010 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1465@ 26th ST Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 7 | Permit Number 46741 | 6012041.28455 | 2101546.95627 | 37.7511259142534 | -122.401196767325 | (37.7511259142534, -122.401196767325) | 10 | 3 | 8 | 28856 | 29 | |
| 146687 | 201989 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013578.50346 | 2092296.28411 | 37.7258111326767 | -122.395232931161 | (37.7258111326767, -122.395232931161) | 10 | 3 | 8 | 58 | 1 | ||||
| 150445 | 176211 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 223 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007229.58334 | 2092624.58551 | 37.7263574447365 | -122.417203995595 | (37.7263574447365, -122.417203995595) | 9 | 3 | 7 | 309 | 28 | |||
| 152816 | 201969 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6013782.62401 | 2092181.31295 | 37.7255067948939 | -122.394519248986 | (37.7255067948939, -122.394519248986) | 10 | 3 | 8 | 58 | 1 | |||
| 153805 | 191048 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 508 Missouri St | 4 | : | Tree | Private 2 | 2 | Width 8ft | 6013509.22069 | 2104630.04045 | 37.7596731815818 | -122.396336524335 | (37.7596731815818, -122.396336524335) | 10 | 3 | 8 | 28856 | 29 | |||
| 155978 | 191039 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 18 | Front Yard : Yard | Tree | Private 2 | 5 | 6015379.43369 | 2102383.15198 | 37.7536075970141 | -122.389711396866 | (37.7536075970141, -122.389711396866) | 10 | 3 | 8 | 28856 | 29 | ||||
| 159517 | 191044 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 801 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6015135.40793 | 2105291.05341 | 37.7615785374414 | -122.390758499125 | (37.7615785374414, -122.390758499125) | 10 | 3 | 8 | 28856 | 29 | ||||
| 160476 | 176200 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6010755.27325 | 2091348.4361 | 37.7230511231959 | -122.404925977947 | (37.7230511231959, -122.404925977947) | 10 | 3 | 7 | 309 | 28 | |||
| 162282 | 103908 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 164179 | 201985 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013611.24152 | 2092292.43846 | 37.7258023939381 | -122.395119487989 | (37.7258023939381, -122.395119487989) | 10 | 3 | 8 | 58 | 1 | |||
| 164527 | 103901 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 168761 | 187583 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 747 University St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6008740.19071 | 2090749.62669 | 37.7212940727358 | -122.411849445609 | (37.7212940727358, -122.411849445609) | 9 | 3 | 7 | 309 | 28 | ||||
| 169414 | 191051 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1998 Revere Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6013034.57444 | 2095940.33474 | 37.7357866816978 | -122.397368703228 | (37.7357866816978, -122.397368703228) | 10 | 3 | 8 | 58 | 1 | ||||
| 173690 | 103907 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 177262 | 38549 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1843 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | 3x3 | Permit Number 40519 | 6015893.6443 | 2093219.8325 | 37.7284754960653 | -122.387293979367 | (37.7284754960653, -122.387293979367) | 10 | 3 | 8 | 58 | 1 |
| 182684 | 201981 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6013639.52945 | 2092282.86186 | 37.7257776715983 | -122.395021027505 | (37.7257776715983, -122.395021027505) | 10 | 3 | 8 | 58 | 1 | |||
| 185760 | 35816 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | 10 | 3 | 7 | 309 | 28 | |
| 186827 | 103909 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 190017 | 103912 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 193469 | 201987 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013596.70102 | 2092297.48635 | 37.7258154458067 | -122.395170107233 | (37.7258154458067, -122.395170107233) | 10 | 3 | 8 | 58 | 1 | |||
| 5569 | 223298 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 352 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007782.78293 | 2105864.77472 | 37.7627431594916 | -122.416228930816 | (37.7627431594916, -122.416228930816) | 8 | 4 | 7 | 28859 | 19 | |||
| 8219 | 223324 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001009.92061 | 2105447.67366 | 37.7612147391902 | -122.439623902619 | (37.7612147391902, -122.439623902619) | 15 | 4 | 5 | 28862 | 3 | |||
| 8750 | 223311 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001071.26024 | 2104220.26116 | 37.7578480551551 | -122.439323773684 | (37.7578480551551, -122.439323773684) | 2 | 4 | 5 | 28862 | 38 | |||
| 14229 | 223305 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004321.04014 | 2103386.46629 | 37.7557430516272 | -122.428025258965 | (37.7557430516272, -122.428025258965) | 2 | 4 | 5 | 28862 | 22 | |||
| 14851 | 64452 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1988 12:00:00 AM | 6 | Permit Number 49675 | 6010720.79087 | 2105970.79652 | 37.763199036617 | -122.406074821405 | (37.763199036617, -122.406074821405) | 8 | 4 | 8 | 28859 | 19 | |
| 24472 | 223309 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6001055.98693 | 2104225.03313 | 37.7578602886488 | -122.4393769371 | (37.7578602886488, -122.4393769371) | 2 | 4 | 5 | 28862 | 38 | |||
| 25652 | 223299 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 267 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006192.90217 | 2101673.64979 | 37.7511457766604 | -122.4214301167 | (37.7511457766604, -122.4214301167) | 2 | 4 | 5 | 28859 | 19 | |||
| 26487 | 223888 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005139.26418 | 2103680.11038 | 37.7565955873218 | -122.42521647029 | (37.7565955873218, -122.42521647029) | 2 | 4 | 5 | 28859 | 19 | |||
| 32854 | 223321 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 6 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003607.59341 | 2104210.23604 | 37.7579645380528 | -122.430551361954 | (37.7579645380528, -122.430551361954) | 2 | 4 | 5 | 28862 | 3 | |||
| 35537 | 222526 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4302 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001855.92203 | 2100330.2514 | 37.7472116402063 | -122.436331694157 | (37.7472116402063, -122.436331694157) | 2 | 4 | 5 | 63 | 22 | |||
| 44018 | 223322 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 7 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003609.4958 | 2104203.70513 | 37.7579467134987 | -122.430544316686 | (37.7579467134987, -122.430544316686) | 2 | 4 | 5 | 28862 | 3 | |||
| 45171 | 223904 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005052.50435 | 2102441.86115 | 37.7531907423722 | -122.425428400012 | (37.7531907423722, -122.425428400012) | 2 | 4 | 5 | 28862 | 22 | |||
| 48722 | 223886 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005095.80391 | 2103679.27098 | 37.7565908272116 | -122.425366711909 | (37.7565908272116, -122.425366711909) | 2 | 4 | 5 | 28859 | 19 | |||
| 49977 | 222516 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001372.11196 | 2100107.80211 | 37.7465733454859 | -122.437988737291 | (37.7465733454859, -122.437988737291) | 2 | 4 | 5 | 63 | 22 | |||
| 52708 | 223317 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 2 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003628.73131 | 2104227.65103 | 37.7580135529078 | -122.430479500748 | (37.7580135529078, -122.430479500748) | 2 | 4 | 5 | 28862 | 3 | |||
| 57902 | 223919 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 293 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006519.52162 | 2104466.46125 | 37.7588326032685 | -122.420498850765 | (37.7588326032685, -122.420498850765) | 2 | 4 | 7 | 28859 | 19 | |||
| 61632 | 191037 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010742.72974 | 2105979.64591 | 37.7632245620984 | -122.405999565232 | (37.7632245620984, -122.405999565232) | 8 | 4 | 8 | 28859 | 19 | |||
| 66478 | 223884 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007476.34391 | 2105418.19682 | 37.7614997244664 | -122.417257150023 | (37.7614997244664, -122.417257150023) | 2 | 4 | 7 | 28859 | 19 | |||
| 69334 | 223301 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4039 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6001871.11422 | 2103502.75724 | 37.7559234475104 | -122.436506195027 | (37.7559234475104, -122.436506195027) | 2 | 4 | 5 | 28862 | 22 | |||
| 74750 | 223909 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005053.21271 | 2102428.99396 | 37.7531554520847 | -122.425425034739 | (37.7531554520847, -122.425425034739) | 2 | 4 | 5 | 28862 | 22 | |||
| 77163 | 223308 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000449.27846 | 2104630.8077 | 37.7589399004855 | -122.441504300502 | (37.7589399004855, -122.441504300502) | 2 | 4 | 5 | 28862 | 38 | |||
| 77650 | 223906 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005052.89667 | 2102434.79152 | 37.7531713529793 | -122.425426540219 | (37.7531713529793, -122.425426540219) | 2 | 4 | 5 | 28862 | 22 | |||
| 82775 | 5564 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1004 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005043.3130716 | 2102494.5958208 | 37.753335020195 | -122.425463937964 | (37.753335020195, -122.425463937964) | 2 | 4 | 5 | 28862 | 22 | |||
| 86240 | 223905 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005052.74936 | 2102437.17406 | 37.7531778865567 | -122.425427219187 | (37.7531778865567, -122.425427219187) | 2 | 4 | 5 | 28862 | 22 | |||
| 86768 | 223900 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005051.2163 | 2102450.92291 | 37.7532155510818 | -122.425433499183 | (37.7532155510818, -122.425433499183) | 2 | 4 | 5 | 28862 | 22 | |||
| 89225 | 223887 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005112.75604 | 2103680.27946 | 37.7565945540051 | -122.42530815707 | (37.7565945540051, -122.42530815707) | 2 | 4 | 5 | 28859 | 19 | |||
| 92585 | 223323 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000992.8223 | 2105437.44063 | 37.7611856686148 | -122.43968230461 | (37.7611856686148, -122.43968230461) | 15 | 4 | 5 | 28862 | 3 | |||
| 94953 | 223306 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004310.1714 | 2103386.37188 | 37.7557421774856 | -122.428062839822 | (37.7557421774856, -122.428062839822) | 2 | 4 | 5 | 28862 | 22 | |||
| 100836 | 223899 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005050.67979 | 2102453.42416 | 37.7532223886195 | -122.425435532533 | (37.7532223886195, -122.425435532533) | 2 | 4 | 5 | 28862 | 22 | |||
| 102677 | 223896 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005049.72495 | 2102468.45452 | 37.7532636045415 | -122.425439904124 | (37.7532636045415, -122.425439904124) | 2 | 4 | 5 | 28862 | 22 | |||
| 111919 | 223897 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005050.02816 | 2102464.15698 | 37.7532518216282 | -122.425438549749 | (37.7532518216282, -122.425438549749) | 2 | 4 | 5 | 28862 | 22 | |||
| 111920 | 223898 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005049.96396 | 2102461.03726 | 37.7532432519759 | -122.425438549767 | (37.7532432519759, -122.425438549767) | 2 | 4 | 5 | 28862 | 22 | |||
| 115500 | 223304 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004328.41422 | 2103387.58746 | 37.7557465472879 | -122.427999836924 | (37.7557465472879, -122.427999836924) | 2 | 4 | 5 | 28862 | 22 | |||
| 124404 | 223320 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 5 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003607.3788 | 2104219.57182 | 37.7579901597246 | -122.430552770305 | (37.7579901597246, -122.430552770305) | 2 | 4 | 5 | 28862 | 3 | |||
| 126098 | 223883 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005389.40986 | 2103549.44963 | 37.7562509518289 | -122.424342082823 | (37.7562509518289, -122.424342082823) | 2 | 4 | 5 | 28859 | 19 | |||
| 130089 | 191036 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010727.3327 | 2105979.27336 | 37.7632226779992 | -122.4060527925 | (37.7632226779992, -122.4060527925) | 8 | 4 | 8 | 28859 | 19 | |||
| 130671 | 223918 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 885 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007588.79194 | 2104568.22054 | 37.7591722115349 | -122.416808017787 | (37.7591722115349, -122.416808017787) | 2 | 4 | 7 | 28859 | 19 | |||
| 136748 | 223316 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 1 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003622.06269 | 2104228.77546 | 37.7580162625599 | -122.430502643895 | (37.7580162625599, -122.430502643895) | 2 | 4 | 5 | 28862 | 3 | |||
| 136963 | 26938 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3 | 6005048.24826 | 2102491.89317 | 37.7533278781854 | -122.425446678723 | (37.7533278781854, -122.425446678723) | 2 | 4 | 5 | 28862 | 22 | |||
| 138450 | 223895 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005049.77309 | 2102470.79439 | 37.7532700319998 | -122.425439904151 | (37.7532700319998, -122.425439904151) | 2 | 4 | 5 | 28862 | 22 | |||
| 139660 | 26940 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3 | 6005048.82283 | 2102481.73773 | 37.7533000261745 | -122.425443969077 | (37.7533000261745, -122.425443969077) | 2 | 4 | 5 | 28862 | 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) );