trees
6,714 rows where qSpecies_id = 7 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13104 | 88055 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 52 Robblee Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498 | 2095923.9 | 37.7357116661186 | -122.399222709682 | (37.7357116661186, -122.399222709682) | 10 | 3 | 8 | 58 | 1 | |||
22718 | 88236 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1593 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51225 | 6001491 | 2111451 | 37.7777257527509 | -122.438390172535 | (37.7777257527509, -122.438390172535) | 15 | 5 | 11 | 29492 | 41 | |||
23921 | 91104 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5100 Fulton St | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2009 12:00:00 AM | 3 | Permit Number 51994 | 5987486.90451 | 2109863.03961 | 37.7725591579684 | -122.486717887734 | (37.7725591579684, -122.486717887734) | 11 | 6 | 2 | 55 | 26 | |||
26035 | 88576 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 565 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51516 | 5990288 | 2111527.4 | 37.7772919335186 | -122.477150362969 | (37.7772919335186, -122.477150362969) | 11 | 6 | 2 | 55 | 26 | |||
42489 | 88104 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1247 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.7632386939753 | -122.50630313345 | (37.7632386939753, -122.50630313345) | 1 | 8 | 3 | 56 | 35 | |||
54346 | 91105 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5100 Fulton St | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2009 12:00:00 AM | 3 | Permit Number 51994 | 5987471.43657 | 2109862.78332 | 37.7725575525108 | -122.48677137341 | (37.7725575525108, -122.48677137341) | 11 | 6 | 2 | 55 | 26 | |||
74762 | 87792 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 88 Neptune St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2008 12:00:00 AM | 3x3 | Permit Number 50533 | 6013015.9 | 2093934.5 | 37.7302780341819 | -122.397292652785 | (37.7302780341819, -122.397292652785) | 10 | 3 | 8 | 58 | 1 | |||
89083 | 88137 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 173 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51165 | 5998746 | 2097919 | 37.7404137307707 | -122.44691203771 | (37.7404137307707, -122.44691203771) | 9 | 7 | 4 | 59 | 40 | |||
118022 | 86728 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 980 Huron Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49704 | 5996769.2 | 2086717.1 | 37.7095428329763 | -122.452938628006 | (37.7095428329763, -122.452938628006) | 9 | 7 | 6 | 28861 | 25 | ||||
137369 | 89325 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 9 Woodland Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51916 | 5997172.6 | 2105981.7 | 37.7624618878583 | -122.452934038904 | (37.7624618878583, -122.452934038904) | 15 | 5 | 11 | 29492 | 12 | ||||
190527 | 106859 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | 10 | 3 | 8 | 28856 | 29 | ||
191077 | 88714 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 871 Page St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51655 | 6002408 | 2109501 | 37.7724236544526 | -122.435078456775 | (37.7724236544526, -122.435078456775) | 15 | 5 | 11 | 29492 | 9 | |||
193374 | 88133 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 782 Foerster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51160 | 5998155 | 2096174 | 37.7355885978434 | -122.448829813464 | (37.7355885978434, -122.448829813464) | 9 | 7 | 4 | 59 | 40 | |||
14286 | 236928 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 563 Ellsworth St | 0 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008012.37418 | 2096216.33991 | 37.7362636335624 | -122.414751994907 | (37.7362636335624, -122.414751994907) | 2 | 7 | 7 | 28859 | 2 | |||
150638 | 121889 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 17th Ave | 0 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5990520.54715 | 2115002.72082 | 37.7868476878607 | -122.476599871638 | (37.7868476878607, -122.476599871638) | 11 | 6 | 1 | 61 | 30 | |||
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
95 | 261359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
199 | 237529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1197 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003874.24561 | 2101347.66783 | 37.7501197023675 | -122.429425031242 | (37.7501197023675, -122.429425031242) | 2 | 4 | 5 | 28862 | 22 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
332 | 182987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1975 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989890.895 | 2098325.8493 | 37.7410209633467 | -122.477558903564 | (37.7410209633467, -122.477558903564) | 1 | 8 | 3 | 29491 | 35 | |||
437 | 202267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.7282842035544 | -122.397179214247 | (37.7282842035544, -122.397179214247) | 10 | 3 | 8 | 58 | 1 | |||
491 | 246210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999854.0817 | 2107930.8602 | 37.7679670970626 | -122.443799851593 | (37.7679670970626, -122.443799851593) | 15 | 5 | 11 | 29492 | 9 | ||
518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
560 | 97763 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | 11 | 6 | 1 | 54 | 31 | ||
587 | 37078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.7619519432804 | -122.50380580728 | (37.7619519432804, -122.50380580728) | 1 | 8 | 3 | 56 | 35 | |
651 | 59344 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 532 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1980 12:00:00 AM | 8 | Permit Number 18692 | 6000155.0247 | 2110781.0357 | 37.7758101209138 | -122.44296363094 | (37.7758101209138, -122.44296363094) | 15 | 5 | 11 | 29492 | 16 | |
681 | 71797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.449903100064 | (37.7733879494567, -122.449903100064) | 15 | 5 | 11 | 29492 | 16 | |||
726 | 213079 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 127 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994523.12061 | 2101041.16824 | 37.7487442639422 | -122.461739308234 | (37.7487442639422, -122.461739308234) | 1 | 8 | 4 | 29491 | 40 | |||
839 | 71209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2170 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988552.6315 | 2100561.3439 | 37.7470812936995 | -122.48234982645 | (37.7470812936995, -122.48234982645) | 1 | 8 | 3 | 29491 | 35 | |||
902 | 213099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 48 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996420.67751 | 2095562.94637 | 37.733811460225 | -122.454781859719 | (37.733811460225, -122.454781859719) | 9 | 7 | 4 | 59 | 40 | |||
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
1159 | 70451 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | 1 | 8 | 3 | 29491 | 35 | |||
1235 | 54485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 524 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1972 12:00:00 AM | 3 | Permit Number 10277 | 5983807.43995 | 2112211.38308 | 37.7787918392432 | -122.499618921418 | (37.7787918392432, -122.499618921418) | 11 | 6 | 2 | 55 | 26 | |
1243 | 237775 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 51 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001962.65396 | 2106203.64248 | 37.763344625173 | -122.43638291504 | (37.763344625173, -122.43638291504) | 15 | 5 | 5 | 28862 | 3 | |||
1251 | 218033 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993104.01352 | 2098691.4194 | 37.7422106578044 | -122.466475770336 | (37.7422106578044, -122.466475770336) | 1 | 8 | 4 | 59 | 40 | |||
1276 | 72277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983524.1138 | 2110218.5518 | 37.7733034736496 | -122.500451657892 | (37.7733034736496, -122.500451657892) | 11 | 6 | 2 | 55 | 26 | |||
1364 | 253839 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3x3 | 6006239 | 2097690 | 37.7402101761268 | -122.42098789234 | (37.7402101761268, -122.42098789234) | 2 | 7 | 7 | 28859 | 2 | |||
1429 | 237519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 155 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004137.76382 | 2100992.35213 | 37.7491590042859 | -122.428488446692 | (37.7491590042859, -122.428488446692) | 2 | 4 | 5 | 28862 | 22 | |||
1471 | 68309 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 273 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 5 | Permit Number 32120 | 5990851.78966 | 2113569.99779 | 37.7829330362374 | -122.47534921912 | (37.7829330362374, -122.47534921912) | 11 | 6 | 2 | 54 | 26 | |
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
1563 | 83933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1858 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51018 | 6000198.5471 | 2111317.0904 | 37.7772844720096 | -122.442851578579 | (37.7772844720096, -122.442851578579) | 15 | 5 | 11 | 29490 | 16 | |
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
1789 | 39904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2807 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2001 12:00:00 AM | 6 | Permit Number 44042 | 6001235.05057 | 2115912.0484 | 37.7899600881353 | -122.439595474174 | (37.7899600881353, -122.439595474174) | 13 | 6 | 1 | 29490 | 27 | |
1797 | 72003 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987539.672 | 2101751.7111 | 37.7502907477313 | -122.485939871711 | (37.7502907477313, -122.485939871711) | 1 | 8 | 3 | 29491 | 35 | |||
1813 | 25410 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.7697058178046 | -122.423571815294 | (37.7697058178046, -122.423571815294) | 8 | 4 | 5 | 28853 | 19 | ||
1853 | 214288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 38 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/23/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42619 | 5999806.95305 | 2093809.09712 | 37.7291894584065 | -122.442948622496 | (37.7291894584065, -122.442948622496) | 9 | 7 | 4 | 63 | 40 | |
1922 | 260512 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 180 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990850 | 2091280 | 37.7217304489912 | -122.473728831815 | (37.7217304489912, -122.473728831815) | 9 | 8 | 4 | 64 | 40 | ||||
1931 | 213034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996575.5142 | 2106308.44603 | 37.7633248140133 | -122.455022738629 | (37.7633248140133, -122.455022738629) | 15 | 5 | 11 | 29492 | 12 | |||
1955 | 55970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.99391 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | 5 | 1 | 10 | 28857 | 21 | ||
1971 | 60793 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 300 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 7 | Permit Number 20467 | 5998509.2912 | 2112152.7993 | 37.779482661953 | -122.448755442586 | (37.779482661953, -122.448755442586) | 15 | 6 | 2 | 54 | 16 | |
2046 | 72250 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | 9 | 7 | 6 | 28861 | 5 | |||
2068 | 214271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 519 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997445.19027 | 2095126.33403 | 37.7326713410914 | -122.451208353186 | (37.7326713410914, -122.451208353186) | 9 | 7 | 4 | 59 | 40 | |||
2132 | 235898 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3623 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 6005449.14976 | 2104867.03319 | 37.7598721008326 | -122.424229185527 | (37.7598721008326, -122.424229185527) | 2 | 4 | 5 | 28859 | 19 | |||
2141 | 70199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990281.69585 | 2112130.11385 | 37.7789464534529 | -122.477216227307 | (37.7789464534529, -122.477216227307) | 11 | 6 | 2 | 55 | 26 | |||
2255 | 236751 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.435700446513 | (37.7555736715096, -122.435700446513) | 2 | 4 | 5 | 28862 | 22 | ||||
2423 | 183529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2590 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988341.8215 | 2097699.5391 | 37.7392112662203 | -122.482869079468 | (37.7392112662203, -122.482869079468) | 1 | 8 | 3 | 29491 | 35 | |||
2466 | 68381 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.7613125625383 | -122.445651023552 | (37.7613125625383, -122.445651023552) | 15 | 5 | 5 | 28862 | 3 | ||
2482 | 31979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 246 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35378 | 5995256.47104 | 2113909.90159 | 37.7841206491804 | -122.460135585049 | (37.7841206491804, -122.460135585049) | 11 | 6 | 2 | 54 | 11 | |
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
2508 | 40281 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 379 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41433 | 6007237.3550509 | 2105117.81917656 | 37.7606615087743 | -122.418062420589 | (37.7606615087743, -122.418062420589) | 2 | 4 | 7 | 28859 | 19 | ||
2535 | 70599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 346 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004344.49924 | 2091141.9903 | 37.7221238322355 | -122.427072045934 | (37.7221238322355, -122.427072045934) | 9 | 7 | 6 | 28861 | 5 | |||
2596 | 70483 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 939 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6005126.74678 | 2092081.98496 | 37.7247490558006 | -122.424434831697 | (37.7247490558006, -122.424434831697) | 9 | 7 | 6 | 28861 | 5 | |||
2634 | 40957 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 735 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 7 | Permit Number 42441 | 5990344.94056 | 2110364.54527 | 37.7741023575346 | -122.476868403223 | (37.7741023575346, -122.476868403223) | 11 | 6 | 2 | 55 | 26 | |
2669 | 248462 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | Permit Number 779787 | 5997458.098 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | 15 | 5 | 11 | 29492 | 9 | ||
2712 | 84610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 535 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987793.08995 | 2112320.51653 | 37.7793245451935 | -122.485839179975 | (37.7793245451935, -122.485839179975) | 11 | 6 | 2 | 55 | 26 | |||
2811 | 246987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004726.23458 | 2101068.69852 | 37.7494019174823 | -122.426458941248 | (37.7494019174823, -122.426458941248) | 2 | 4 | 5 | 28862 | 22 | |||
2821 | 212702 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1350 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994593.65798 | 2106323.94898 | 37.7632534869818 | -122.461878404565 | (37.7632534869818, -122.461878404565) | 15 | 5 | 11 | 56 | 12 | |||
2984 | 261389 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010649.76194 | 2118553.23001 | 37.7977434736118 | -122.407207494731 | (37.7977434736118, -122.407207494731) | 3 | 1 | 10 | 308 | 4 | |||||
2987 | 212886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1941 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5990935.1255 | 2102170.56129 | 37.7516380862328 | -122.474228847281 | (37.7516380862328, -122.474228847281) | 1 | 8 | 4 | 29491 | 12 | |||
3116 | 71316 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 558 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6003372.2866 | 2090101.06042 | 37.7192106439431 | -122.430358515827 | (37.7192106439431, -122.430358515827) | 9 | 7 | 6 | 28861 | 5 | |||
3128 | 236759 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 239 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004655.95554 | 2096917.75381 | 37.7380004006851 | -122.426406454101 | (37.7380004006851, -122.426406454101) | 2 | 7 | 5 | 63 | 7 | |||
3145 | 68594 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.7548904064419 | -122.473207725085 | (37.7548904064419, -122.473207725085) | 1 | 8 | 4 | 56 | 12 | ||
3151 | 47936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45671 | 5996315.56567541 | 2094902.75702129 | 37.7319927097789 | -122.455097570602 | (37.7319927097789, -122.455097570602) | 9 | 7 | 4 | 59 | 40 | ||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
3278 | 72888 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2506 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989566.1304 | 2098258.2718 | 37.7408165618747 | -122.478676867492 | (37.7408165618747, -122.478676867492) | 1 | 8 | 3 | 29491 | 35 | |||
3291 | 237670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003090.82539 | 2107383.74854 | 37.7666489493115 | -122.432565239916 | (37.7666489493115, -122.432565239916) | 15 | 5 | 5 | 28862 | 3 | |||
3299 | 178756 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 47 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008299.13366 | 2086795.43914 | 37.7104119441216 | -122.413094604643 | (37.7104119441216, -122.413094604643) | 9 | 7 | 8 | 309 | 39 | |||
3353 | 261197 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
3475 | 78427 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001123.96924 | 2089480.39079 | 37.7173788130682 | -122.438085642862 | (37.7173788130682, -122.438085642862) | 9 | 7 | 6 | 28861 | 5 | |||
3539 | 65220 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 438 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 28007 | 6002076.3517 | 2091079.52692 | 37.7218238013198 | -122.434908002604 | (37.7218238013198, -122.434908002604) | 9 | 7 | 6 | 28861 | 5 | |
3582 | 71321 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 336 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004246.97959 | 2090473.39754 | 37.7202825081141 | -122.427361543098 | (37.7202825081141, -122.427361543098) | 9 | 7 | 6 | 28861 | 5 | |||
3609 | 68347 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.480420503546 | (37.7787654076266, -122.480420503546) | 11 | 6 | 2 | 55 | 26 | |
3610 | 45141 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | 15 | 5 | 11 | 29492 | 9 | ||
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
3695 | 217936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2035 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 4 | Width 3ft | Permit Number 47390 | 5991589.39044 | 2101578.98372 | 37.7500516488693 | -122.471923224775 | (37.7500516488693, -122.471923224775) | 1 | 8 | 4 | 29491 | 12 | |
3723 | 260511 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 199X Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990954 | 2091213 | 37.7215525064104 | -122.47336445039 | (37.7215525064104, -122.47336445039) | 9 | 8 | 4 | 64 | 40 | ||||
3756 | 261450 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006908 | 2095729 | 37.7348633927281 | -122.418535734777 | (37.7348633927281, -122.418535734777) | 2 | 7 | 7 | 28859 | 2 | ||||
3803 | 84348 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3332-3334 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50580 | 6007340.92664153 | 2105019.75450207 | 37.760398074706 | -122.417697261406 | (37.760398074706, -122.417697261406) | 2 | 4 | 7 | 28859 | 19 | ||
3888 | 66831 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 356 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30128 | 6001116.30976088 | 2104258.47469613 | 37.7579555437732 | -122.439170712808 | (37.7579555437732, -122.439170712808) | 2 | 4 | 5 | 28862 | 38 | ||
3895 | 78222 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) | 9 | 3 | 7 | 309 | 28 | |||
3923 | 25589 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6009160.7320011 | 2097455.9675675 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | 10 | 7 | 7 | 28859 | 2 | |||
3940 | 60357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | 10 | 3 | 8 | 58 | 1 | |
3972 | 73489 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 45 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000901.50106 | 2088195.84142 | 37.7138390733861 | -122.438762613813 | (37.7138390733861, -122.438762613813) | 9 | 7 | 6 | 28861 | 5 | |||
4085 | 212397 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991907.97112 | 2095768.21214 | 37.7341151819682 | -122.470398435962 | (37.7341151819682, -122.470398435962) | 9 | 8 | 4 | 59 | 40 | |||
4104 | 78658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 650 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012076.11303 | 2105354.08238 | 37.761581389203 | -122.401343843369 | (37.761581389203, -122.401343843369) | 10 | 3 | 8 | 28856 | 29 | |||
4223 | 54535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 107 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1972 12:00:00 AM | 8 | Permit Number 10330 | 6009992.40019 | 2095186.16028 | 37.7335460325239 | -122.407833574281 | (37.7335460325239, -122.407833574281) | 10 | 3 | 7 | 309 | 28 | |
4420 | 54537 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1972 12:00:00 AM | 5 | Permit Number 10332 | 6009964.96309 | 2095176.72453 | 37.7335185878995 | -122.407927767479 | (37.7335185878995, -122.407927767479) | 10 | 3 | 7 | 309 | 28 | |
4424 | 261436 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 375 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007268 | 2095787 | 37.7350429085654 | -122.417295195055 | (37.7350429085654, -122.417295195055) | 2 | 7 | 7 | 28859 | 2 | ||||
4548 | 47112 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 195 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45096 | 6007059.72881336 | 2097900.35480797 | 37.7408339935349 | -122.418165045885 | (37.7408339935349, -122.418165045885) | 2 | 7 | 7 | 28859 | 2 |
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) );