trees
368 rows where qSpecies_id = 144 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 103791 | 247051 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 519 Valley St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.7439854383853 | -122.433950739945 | (37.7439854383853, -122.433950739945) | 2 | 7 | 5 | 63 | 22 | |||
| 114617 | 126466 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1454 Jefferson St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6002229.50712 | 2121606.26883 | 37.8056514799082 | -122.436562488975 | (37.8056514799082, -122.436562488975) | 13 | 9 | 1 | 57 | 17 | |||
| 136651 | 247815 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 536 30th St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6003101.83098 | 2098352.54128 | 37.7418520216442 | -122.431882247061 | (37.7418520216442, -122.431882247061) | 2 | 7 | 5 | 63 | 22 | |||
| 149840 | 247049 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 527 Valley St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002466.92979 | 2099138.14647 | 37.7439730978735 | -122.434133672824 | (37.7439730978735, -122.434133672824) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 141942 | 223319 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 4 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003647.0575 | 2104227.27295 | 37.7580135529116 | -122.430416094033 | (37.7580135529116, -122.430416094033) | 2 | 4 | 5 | 28862 | 3 | |||
| 186113 | 223318 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 3 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003637.29181 | 2104227.88023 | 37.7580146671663 | -122.430449911261 | (37.7580146671663, -122.430449911261) | 2 | 4 | 5 | 28862 | 3 | |||
| 39010 | 223338 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 17 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.7361200361187 | -122.433668499417 | (37.7361200361187, -122.433668499417) | 2 | 7 | 5 | 63 | 7 | |||
| 100927 | 223337 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 21 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6002002.72042 | 2096679.58594 | 37.7371961064217 | -122.435562951888 | (37.7371961064217, -122.435562951888) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | |||
| 28526 | 111267 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700X BOSWORTH ST | 5 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 72823 | 111277 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700X BOSWORTH ST | 15 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||||
| 100112 | 223885 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1201 San Jose Ave | 53 | Front Yard : Yard | Tree | Private 2 | 4 | 6004491.44373 | 2096094.26439 | 37.7357299839367 | -122.426916620606 | (37.7357299839367, -122.426916620606) | 2 | 7 | 5 | 28861 | 2 | ||||
| 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 | |||
| 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 | ||||
| 138631 | 247963 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 14 Joy St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6010355.27256 | 2098907.44942 | 37.7437842015769 | -122.406841193976 | (37.7437842015769, -122.406841193976) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 145776 | 223310 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001063.6909 | 2104223.05336 | 37.7578552911032 | -122.439350151704 | (37.7578552911032, -122.439350151704) | 2 | 4 | 5 | 28862 | 38 | |||
| 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 | ||||
| 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 | |||
| 163431 | 223312 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001075.55529 | 2104217.42481 | 37.7578405116468 | -122.439308716341 | (37.7578405116468, -122.439308716341) | 2 | 4 | 5 | 28862 | 38 | |||
| 165279 | 223313 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001079.43787 | 2104214.39787 | 37.7578324213507 | -122.439295071829 | (37.7578324213507, -122.439295071829) | 2 | 4 | 5 | 28862 | 38 | |||
| 170383 | 247962 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 14 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6010359.95763 | 2098907.35395 | 37.7437842015861 | -122.406824987307 | (37.7437842015861, -122.406824987307) | 2 | 7 | 7 | 28859 | 2 | ||||
| 9963 | 457 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 760x 23rd Ave | 25 | Median : Cutout | Tree | DPW 1 | 10/31/2002 12:00:00 AM | 3 | 5988833.54517 | 2109972.18567 | 37.7729372568337 | -122.482067772117 | (37.7729372568337, -122.482067772117) | 11 | 6 | 2 | 55 | 26 | |||
| 19872 | 207443 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 220x Vasquez Ave | 2 | Median : Cutout | Tree | DPW 1 | 10 | Width 6ft | 5994526.33722 | 2099104.46758 | 37.743426756136 | -122.461587791356 | (37.743426756136, -122.461587791356) | 1 | 8 | 4 | 59 | 40 | |||
| 65808 | 23596 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 200X Vasquez Ave | 7 | Median : Cutout | Tree | DPW 1 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
| 115430 | 207444 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 220x Vasquez Ave | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5994513.07685 | 2099093.39362 | 37.7433955865283 | -122.461632839295 | (37.7433955865283, -122.461632839295) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | ||||
| 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 | ||||
| 60811 | 247865 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 400 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6009511.40819 | 2098411.13384 | 37.742374173428 | -122.409724064332 | (37.742374173428, -122.409724064332) | 10 | 7 | 7 | 28859 | 2 | ||||
| 122928 | 207514 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 747 Detroit St | 2 | Side Yard : Yard | Tree | Private 2 | 2 | 5999418.54493 | 2095450.46717 | 37.7336741238608 | -122.444409289657 | (37.7336741238608, -122.444409289657) | 9 | 7 | 4 | 59 | 40 | ||||
| 127869 | 207505 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 404 Baden St | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6000763.51144 | 2095280.18835 | 37.7332832254367 | -122.439747153813 | (37.7332832254367, -122.439747153813) | 9 | 7 | 5 | 63 | 40 | ||||
| 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 | ||||
| 170167 | 247006 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 401 Valley St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 6003253.92203 | 2099189.92697 | 37.7441599095582 | -122.43141613026 | (37.7441599095582, -122.43141613026) | 2 | 7 | 5 | 63 | 22 | |||
| 191465 | 247864 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 399 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6009555.15097 | 2098432.68764 | 37.7424358066648 | -122.409574335293 | (37.7424358066648, -122.409574335293) | 10 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||
| 4052 | 70478 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 64 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6005133.63809 | 2092919.23078 | 37.7270483380922 | -122.424470534798 | (37.7270483380922, -122.424470534798) | 9 | 7 | 6 | 28861 | 5 | |||
| 4110 | 117662 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5983913.56445 | 2111711.8528 | 37.7774265003929 | -122.49921487984 | (37.7774265003929, -122.49921487984) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 8210 | 69414 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 79 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 8 | Permit Number 33519 | 6001925 | 2087361 | 37.7116049578173 | -122.435165351533 | (37.7116049578173, -122.435165351533) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 10856 | 207523 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997186.60025 | 2095013.78358 | 37.7323474952197 | -122.452094240274 | (37.7323474952197, -122.452094240274) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 14838 | 72275 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 745 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983802 | 2110725 | 37.7747103425962 | -122.499527862048 | (37.7747103425962, -122.499527862048) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |
| 19131 | 248105 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6010429.9574 | 2099572.50671 | 37.7456144829387 | -122.406629807421 | (37.7456144829387, -122.406629807421) | 2 | 7 | 7 | 28859 | 2 | |||
| 22532 | 223297 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 216 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007815.61312 | 2100277.20089 | 37.7474028010032 | -122.415719727502 | (37.7474028010032, -122.415719727502) | 2 | 7 | 7 | 28859 | 2 | |||
| 23135 | 223891 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008990.48886 | 2099085.34531 | 37.7441962044045 | -122.4115728771 | (37.7441962044045, -122.4115728771) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 28292 | 207450 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5996939.36617 | 2093634.85846 | 37.7285471311368 | -122.452849488219 | (37.7285471311368, -122.452849488219) | 9 | 7 | 4 | 28861 | 40 | |||
| 29200 | 207442 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 67 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993137.43187 | 2098655.60003 | 37.7421142351796 | -122.466357618327 | (37.7421142351796, -122.466357618327) | 1 | 8 | 4 | 59 | 40 | |||
| 31339 | 126467 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2711 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001788.68499 | 2115988.81164 | 37.7902023547025 | -122.437685450844 | (37.7902023547025, -122.437685450844) | 13 | 6 | 1 | 29490 | 27 | |||
| 31507 | 94354 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 31558 | 94351 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 33316 | 223332 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004952.54883 | 2097554.13127 | 37.7397645108307 | -122.425426258725 | (37.7397645108307, -122.425426258725) | 2 | 7 | 5 | 63 | 7 | |||
| 34710 | 223920 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 603 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006073.38987 | 2099874.4724 | 37.7461989073679 | -122.421715625397 | (37.7461989073679, -122.421715625397) | 2 | 7 | 5 | 28859 | 2 | |||
| 36913 | 223293 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 101X Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998863.8718 | 2107567.85033 | 37.7669138338245 | -122.447198734836 | (37.7669138338245, -122.447198734836) | 15 | 5 | 11 | 29492 | 9 | |||
| 38045 | 117665 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5983866.28213 | 2111708.82719 | 37.7774154190485 | -122.499378218726 | (37.7774154190485, -122.499378218726) | 11 | 6 | 2 | 55 | 26 | |||
| 39165 | 34706 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 640 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38363 | 5981668.46483 | 2111340.0522 | 37.776273682439 | -122.506953696253 | (37.776273682439, -122.506953696253) | 11 | 6 | 2 | 55 | 26 | |
| 40152 | 94349 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43034 | 207457 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 409 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998694.02737 | 2094363.85027 | 37.7306491651155 | -122.446835986997 | (37.7306491651155, -122.446835986997) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 46710 | 207439 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 306 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993339.70707 | 2104624.44622 | 37.7585148278031 | -122.466091864152 | (37.7585148278031, -122.466091864152) | 1 | 8 | 4 | 56 | 12 | |||
| 48083 | 207440 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 337 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993165.92576 | 2104561.2758 | 37.7583313508388 | -122.466688281042 | (37.7583313508388, -122.466688281042) | 1 | 8 | 4 | 56 | 12 | |||
| 48584 | 223327 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002483.76265 | 2096988.16335 | 37.738070698907 | -122.433921821343 | (37.738070698907, -122.433921821343) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | ||
| 54506 | 223912 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 69 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007426.45015 | 2098992.55773 | 37.7438535743744 | -122.416974423853 | (37.7438535743744, -122.416974423853) | 2 | 7 | 7 | 28859 | 2 | |||
| 57488 | 207427 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1466 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991507.09847 | 2105443.15069 | 37.7606568753312 | -122.472489472137 | (37.7606568753312, -122.472489472137) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 58422 | 115364 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 69 ELSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007449 | 2098988 | 37.743842328307 | -122.416896128684 | (37.743842328307, -122.416896128684) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 63985 | 122196 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 131 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991469.44063 | 2114555.28767 | 37.7856741515485 | -122.473284307608 | (37.7856741515485, -122.473284307608) | 11 | 6 | 2 | 54 | 26 | |||
| 64574 | 207501 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 421 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995678.51493 | 2095805.70725 | 37.7344354233544 | -122.457365278307 | (37.7344354233544, -122.457365278307) | 9 | 7 | 4 | 59 | 40 | |||
| 66067 | 117664 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5983878.87513 | 2111710.17251 | 37.7774198517188 | -122.499334755526 | (37.7774198517188, -122.499334755526) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 |
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) );