trees
6,714 rows where qSpecies_id = 7 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194512 | 246989 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 74 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6004681.91881 | 2101068.44983 | 37.7493987293702 | -122.426612168643 | (37.7493987293702, -122.426612168643) | 2 | 4 | 5 | 28862 | 22 | |||
194452 | 237613 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 105 Danvers St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999967 | 2105076 | 37.7601348010019 | -122.443204214657 | (37.7601348010019, -122.443204214657) | 2 | 4 | 5 | 28862 | 3 | |||
194411 | 236860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 785228 | 5996892.19398 | 2106024.42834 | 37.7625631359112 | -122.453906940775 | (37.7625631359112, -122.453906940775) | 15 | 5 | 11 | 29492 | 12 | ||
194321 | 212968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 6x8 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |||
194320 | 206251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 05:08:00 PM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
194317 | 264994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194315 | 264988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
194314 | 214535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194312 | 264991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
194311 | 264987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
194310 | 264995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194307 | 212966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994457.81868 | 2106649.28176 | 37.7641389450798 | -122.462371822121 | (37.7641389450798, -122.462371822121) | 1 | 5 | 11 | 56 | 12 | |||
194305 | 212967 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994483.48694 | 2106651.50195 | 37.7641465191771 | -122.462283204732 | (37.7641465191771, -122.462283204732) | 1 | 5 | 11 | 56 | 12 | |||
194292 | 214534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993542.41381 | 2106613.40944 | 37.7639876944061 | -122.465535310621 | (37.7639876944061, -122.465535310621) | 1 | 8 | 11 | 56 | 12 | |
194290 | 264989 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 6x8 | Permit Number 780527 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |
194289 | 264993 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993487.77014 | 2106611.56006 | 37.7639794646992 | -122.465724170953 | (37.7639794646992, -122.465724170953) | 1 | 8 | 11 | 56 | 12 | |
194288 | 264990 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 6x8 | Permit Number 780527 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |
194238 | 237813 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1844 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004559.56725 | 2098005.68328 | 37.7409821586963 | -122.42681717267 | (37.7409821586963, -122.42681717267) | 2 | 7 | 5 | 63 | 7 | |||
194220 | 48629 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1417 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45926 | 5991770.27405058 | 2105778.87333807 | 37.761593910046 | -122.471603740431 | (37.761593910046, -122.471603740431) | 1 | 8 | 4 | 56 | 12 | ||
194179 | 140866 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 14 WOOD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998542.6865 | 2113716.6052 | 37.7837783751705 | -122.448752581825 | (37.7837783751705, -122.448752581825) | 15 | 6 | 1 | 54 | 31 | |||
194159 | 10077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005621.78486 | 2105416.82041 | 37.7613914334809 | -122.423671214664 | (37.7613914334809, -122.423671214664) | 2 | 4 | 5 | 28859 | 19 | |||
194106 | 236306 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 203 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006734.70469 | 2102538.96292 | 37.7535522617457 | -122.419617890181 | (37.7535522617457, -122.419617890181) | 2 | 4 | 7 | 28859 | 19 | |||
194084 | 236889 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 48 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999976.29127 | 2107035.94612 | 37.7655168566322 | -122.443312857817 | (37.7655168566322, -122.443312857817) | 15 | 5 | 5 | 29492 | 9 | |||
194028 | 237836 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 173 Addison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002602.01545 | 2097466.73849 | 37.7393914657462 | -122.43354715478 | (37.7393914657462, -122.43354715478) | 2 | 7 | 5 | 63 | 7 | |||
193976 | 50756 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1422 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2004 12:00:00 AM | 1 | 3x3 | Permit Number 47297 | 6000959.9949 | 2110735.2278 | 37.7757302056015 | -122.440175755869 | (37.7757302056015, -122.440175755869) | 15 | 5 | 11 | 29492 | 10 | |
193882 | 237792 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Loma Vista Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999972.01811 | 2106843.52449 | 37.7649882711282 | -122.443313815582 | (37.7649882711282, -122.443313815582) | 15 | 5 | 5 | 29492 | 3 | |||
193881 | 237767 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 254 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000562.50875 | 2106686.52156 | 37.7645908346098 | -122.441260195715 | (37.7645908346098, -122.441260195715) | 15 | 5 | 5 | 28862 | 3 | |||
193854 | 237647 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3666 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003934.60514 | 2103659.35209 | 37.7564704610534 | -122.429381133547 | (37.7564704610534, -122.429381133547) | 2 | 4 | 5 | 28862 | 3 | |||
193851 | 4405 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.427774340913 | (37.7540702011025, -122.427774340913) | 2 | 4 | 5 | 28862 | 22 | ||
193828 | 50603 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
193824 | 236542 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6006772.47407 | 2097100.67096 | 37.7386220669602 | -122.419101558803 | (37.7386220669602, -122.419101558803) | 2 | 7 | 7 | 28859 | 2 | |||
193782 | 213097 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 240 Maywood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994307.44781 | 2095118.63694 | 37.7324700521364 | -122.462055663638 | (37.7324700521364, -122.462055663638) | 9 | 8 | 4 | 59 | 40 | |||
193769 | 236816 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 58 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997113.90402 | 2106173.00443 | 37.7629837973781 | -122.453150856453 | (37.7629837973781, -122.453150856453) | 15 | 5 | 11 | 29492 | 12 | |||
193687 | 64848 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3991 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1989 12:00:00 AM | 6 | Permit Number 25863 | 5995564.04797 | 2115455.56928 | 37.7883823228668 | -122.459183449867 | (37.7883823228668, -122.459183449867) | 11 | 6 | 1 | 54 | 31 | ||
193652 | 64496 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1548 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | Permit Number 25375 | 6000395.90025246 | 2110653.11374306 | 37.7754726099708 | -122.442121199098 | (37.7754726099708, -122.442121199098) | 15 | 5 | 11 | 29492 | 16 | ||
193592 | 68615 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1926 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32520 | 5990980.83795372 | 2102284.63061067 | 37.7519539388073 | -122.474079091331 | (37.7519539388073, -122.474079091331) | 1 | 8 | 4 | 29491 | 12 | ||
193591 | 47391 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 789 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45306 | 5995339.87116689 | 2110345.66733656 | 37.7743390069649 | -122.459588816877 | (37.7743390069649, -122.459588816877) | 11 | 6 | 2 | 54 | 11 | |||
193561 | 32655 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 567 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37088 | 6011454.94756 | 2109764.70712 | 37.7736572895782 | -122.403802580838 | (37.7736572895782, -122.403802580838) | 14 | 2 | 9 | 28853 | 34 |
193550 | 36501 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 202 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39381 | 6007894.41646621 | 2097691.91332434 | 37.7403086056831 | -122.415264247706 | (37.7403086056831, -122.415264247706) | 2 | 7 | 7 | 28859 | 2 | ||
193528 | 135805 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1748 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006376.79071 | 2116674.3481 | 37.7923444732727 | -122.421859643731 | (37.7923444732727, -122.421859643731) | 13 | 9 | 10 | 28858 | 32 | |||
193519 | 87130 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 539 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50079 | 5987777.8 | 2112308.8 | 37.7792914839248 | -122.485891213403 | (37.7792914839248, -122.485891213403) | 11 | 6 | 2 | 55 | 26 | ||
193516 | 47708 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 283 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45503 | 6001687.89351139 | 2096174.25192012 | 37.7357906900295 | -122.436615290037 | (37.7357906900295, -122.436615290037) | 2 | 7 | 5 | 63 | 7 | ||
193500 | 68043 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1823 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31780 | 5993105.45691397 | 2103063.19350901 | 37.7542145156657 | -122.466788507311 | (37.7542145156657, -122.466788507311) | 1 | 8 | 4 | 56 | 12 | ||
193447 | 213078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993894.40361 | 2102304.56448 | 37.7521770157735 | -122.464005088976 | (37.7521770157735, -122.464005088976) | 1 | 8 | 4 | 29491 | 40 | |||
193446 | 218055 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 30 San Rafael Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5991874.63554 | 2095768.08089 | 37.7341128940943 | -122.470513676886 | (37.7341128940943, -122.470513676886) | 9 | 8 | 4 | 59 | 40 | |||
193414 | 236705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4245 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002171.53394 | 2101176.65808 | 37.7495536007292 | -122.435300867857 | (37.7495536007292, -122.435300867857) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
193359 | 236818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 46 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997100.45954 | 2106270.27738 | 37.7632501136112 | -122.453204378701 | (37.7632501136112, -122.453204378701) | 15 | 5 | 11 | 29492 | 12 | |||
193343 | 182991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1935 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989960.7787 | 2098328.4105 | 37.7410320507911 | -122.477317461003 | (37.7410320507911, -122.477317461003) | 1 | 8 | 3 | 29491 | 35 | |||
193263 | 31716 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1137 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 10 | Permit Number 35216 | 5997692.23217 | 2106590.38684 | 37.7641629524737 | -122.451180729604 | (37.7641629524737, -122.451180729604) | 15 | 5 | 11 | 29492 | 9 | |
193214 | 140238 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2076 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997888.9398 | 2110301.032 | 37.7743626959084 | -122.45076793942 | (37.7743626959084, -122.45076793942) | 15 | 5 | 11 | 29492 | 16 | |||
193211 | 32385 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 106 Park St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | 2 | 7 | 7 | 28859 | 2 | ||
193209 | 236933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 171 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008662.17071 | 2097767.08909 | 37.7405581409552 | -122.412614962934 | (37.7405581409552, -122.412614962934) | 10 | 7 | 7 | 28859 | 2 | |||
193205 | 64507 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 848 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 6 | Permit Number 25388 | 6000492.1653 | 2111922.2928 | 37.7789629386767 | -122.441879309268 | (37.7789629386767, -122.441879309268) | 15 | 5 | 11 | 29490 | 41 | |
193195 | 202165 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013169.46886 | 2093279.75554 | 37.7284887885067 | -122.396715858357 | (37.7284887885067, -122.396715858357) | 10 | 3 | 8 | 58 | 1 | |||
193166 | 237456 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4341 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001639.51696 | 2101144.64329 | 37.7494354684821 | -122.437138304192 | (37.7494354684821, -122.437138304192) | 2 | 4 | 5 | 28862 | 22 | |||
193165 | 218374 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 330 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5993611.56276 | 2100060.41959 | 37.7459988612658 | -122.464820231782 | (37.7459988612658, -122.464820231782) | 1 | 8 | 4 | 29491 | 40 | |||
193157 | 42032 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 253 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42354 | 6004935.64730141 | 2098985.47587644 | 37.743693702604 | -122.425586540761 | (37.743693702604, -122.425586540761) | 2 | 7 | 5 | 63 | 22 | ||
193073 | 235809 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 27 Brosnan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005899.11914 | 2108070.63444 | 37.7686938295852 | -122.422900646768 | (37.7686938295852, -122.422900646768) | 8 | 4 | 5 | 28853 | 19 | |||
193072 | 10119 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 850 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/1992 12:00:00 AM | 18 | 3X3 | 6005631.880167 | 2104012.3184419 | 37.757535570368 | -122.423536442741 | (37.757535570368, -122.423536442741) | 2 | 4 | 5 | 28859 | 19 | ||
193038 | 213090 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 74 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993755.94584 | 2093221.32072 | 37.7272287196112 | -122.463824656206 | (37.7272287196112, -122.463824656206) | 9 | 8 | 4 | 59 | 40 | |||
193035 | 26124 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.7328405153421 | -122.387408617446 | (37.7328405153421, -122.387408617446) | 10 | 3 | 8 | 58 | 1 | |||
193023 | 178846 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 272 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008639.83625 | 2086484.9507 | 37.7095785270867 | -122.411895133863 | (37.7095785270867, -122.411895133863) | 9 | 7 | 8 | 309 | 39 | |||
193014 | 67439 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2950 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1992 12:00:00 AM | 2 | Permit Number 30941 | 5989439.48951 | 2111967.20022 | 37.77845023816 | -122.48011779645 | (37.77845023816, -122.48011779645) | 11 | 6 | 2 | 55 | 26 | |
193010 | 45262 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 643 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44108 | 6007818.28378523 | 2095937.31583806 | 37.7354865872945 | -122.415403300278 | (37.7354865872945, -122.415403300278) | 2 | 7 | 7 | 28859 | 2 | ||
193009 | 135790 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 299 Larch St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006313.68731 | 2113004.80337 | 37.7822652512815 | -122.421817212808 | (37.7822652512815, -122.421817212808) | 7 | 9 | 11 | 28852 | 41 | |||
192993 | 218092 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 44 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995654.33408 | 2092842.93015 | 37.7262989645119 | -122.457234621185 | (37.7262989645119, -122.457234621185) | 9 | 7 | 4 | 28861 | 40 | |||
192941 | 45078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2011 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 2 | Permit Number 43961 | 5987236.9158 | 2101566.1283 | 37.7497635394931 | -122.48697318154 | (37.7497635394931, -122.48697318154) | 1 | 8 | 3 | 29491 | 35 | |
192939 | 67366 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 731 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 7 | Permit Number 30859 | 5992856.23325 | 2110462.25519 | 37.7745159994342 | -122.468188588979 | (37.7745159994342, -122.468188588979) | 11 | 6 | 2 | 54 | 11 | |
192934 | 202260 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 Orsi Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013134.08595 | 2093138.8996 | 37.7281000574664 | -122.396828308676 | (37.7281000574664, -122.396828308676) | 10 | 3 | 8 | 58 | 1 | |||
192891 | 43495 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 4133 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44255 | 6008360.0439071 | 2095929.90950341 | 37.7354966862238 | -122.413529701222 | (37.7354966862238, -122.413529701222) | 10 | 7 | 7 | 28859 | 2 | ||
192853 | 236822 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 12 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1988 12:00:00 AM | 10 | Width 3ft | Permit Number 25632 | 5997059.6674 | 2106561.87629 | 37.7640484318992 | -122.453366518365 | (37.7640484318992, -122.453366518365) | 15 | 5 | 11 | 29492 | 12 | |
192847 | 212974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1350 07th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993967.9273 | 2106474.42991 | 37.763630625777 | -122.464053507576 | (37.763630625777, -122.464053507576) | 1 | 5 | 11 | 56 | 12 | |||
192836 | 248485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 771 Ashbury St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999070.9657 | 2107769.7551 | 37.7674800442213 | -122.446496960318 | (37.7674800442213, -122.446496960318) | 15 | 5 | 11 | 29492 | 9 | |||
192728 | 38244 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 260 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 1 | Permit Number 40357 | 6011482.21729 | 2111475.20283 | 37.7783554397011 | -122.403828635978 | (37.7783554397011, -122.403828635978) | 14 | 2 | 9 | 28856 | 34 | ||
192700 | 212899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1952 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991292.44424 | 2102103.11551 | 37.7514735912445 | -122.472988287395 | (37.7514735912445, -122.472988287395) | 1 | 8 | 4 | 29491 | 12 | |||
192666 | 51403 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1558 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 4 | Permit Number 47729 | 5989964.2494 | 2104747.2913 | 37.7586568103937 | -122.477774564155 | (37.7586568103937, -122.477774564155) | 1 | 8 | 3 | 56 | 35 | |
192650 | 236959 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 124 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005976.70353 | 2098182.3984 | 37.7415474023941 | -122.421929778238 | (37.7415474023941, -122.421929778238) | 2 | 7 | 7 | 28859 | 2 | |||
192586 | 135830 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 8 | Front Yard : Yard | Tree | Private 2 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.414174944941 | (37.7988979472514, -122.414174944941) | 5 | 1 | 10 | 308 | 32 | ||||
192578 | 114493 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 322 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014211.87183 | 2111751.31287 | 37.7792656912091 | -122.394405010779 | (37.7792656912091, -122.394405010779) | 6 | 2 | 9 | 28856 | 34 | |||
192568 | 212900 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1952 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991290.87185 | 2102118.6659 | 37.7515161975232 | -122.472994858721 | (37.7515161975232, -122.472994858721) | 1 | 8 | 4 | 29491 | 12 | |||
192529 | 183977 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1693 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985918.7806 | 2103713.7918 | 37.7555834944248 | -122.49168936146 | (37.7555834944248, -122.49168936146) | 1 | 8 | 3 | 56 | 35 | |||
192514 | 43687 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 182 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 6 | Permit Number 43331 | 5993380.89415 | 2114309.84723 | 37.7851107334379 | -122.466653434648 | (37.7851107334379, -122.466653434648) | 11 | 6 | 2 | 54 | 11 | |
192492 | 51397 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Ringold St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 5 | 2x3 | Permit Number 47723 | 6009698.00166 | 2110029.82687 | 37.7742869382121 | -122.409898870931 | (37.7742869382121, -122.409898870931) | 8 | 2 | 9 | 28853 | 34 |
192489 | 117727 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 432 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5983474.89929 | 2112887.77436 | 37.7806294945058 | -122.500819324845 | (37.7806294945058, -122.500819324845) | 11 | 6 | 2 | 55 | 26 | |||
192385 | 178716 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 551 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001935.51656 | 2090267.4815 | 37.7195861090873 | -122.435336775094 | (37.7195861090873, -122.435336775094) | 9 | 7 | 6 | 28861 | 5 | |||
192380 | 196132 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1333 Rhode Island St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012008.04219 | 2102176.90375 | 37.7528537582936 | -122.401355988713 | (37.7528537582936, -122.401355988713) | 10 | 3 | 8 | 28856 | 29 | |||
192351 | 237533 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 150 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004098.38914 | 2102228.75942 | 37.7525516616378 | -122.428712732213 | (37.7525516616378, -122.428712732213) | 2 | 4 | 5 | 28862 | 22 | |||
192304 | 43366 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 4417 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43116 | 6001242.48275647 | 2101120.64708862 | 37.7493470039303 | -122.438509536884 | (37.7493470039303, -122.438509536884) | 2 | 4 | 5 | 28862 | 22 | ||
192301 | 139089 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2301 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001091.8596 | 2113821.7283 | 37.7842124575353 | -122.439940960044 | (37.7842124575353, -122.439940960044) | 15 | 6 | 11 | 29490 | 13 | |||
192294 | 236859 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1490 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996883.80485 | 2106087.6107 | 37.7627361375951 | -122.453940518737 | (37.7627361375951, -122.453940518737) | 15 | 5 | 11 | 29492 | 12 | |||
192278 | 235980 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 412 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004129.70882 | 2110250.68111 | 37.774579708026 | -122.429176365099 | (37.774579708026, -122.429176365099) | 7 | 9 | 11 | 28852 | 10 | |||
192169 | 212333 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 523 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993222.06519 | 2105245.5495 | 37.7602134277179 | -122.466543863418 | (37.7602134277179, -122.466543863418) | 1 | 8 | 4 | 56 | 12 | |||
192101 | 236259 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 409 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008964.70547 | 2106225.4221 | 37.7637998026406 | -122.412166554647 | (37.7637998026406, -122.412166554647) | 8 | 4 | 7 | 28859 | 19 | |||
192092 | 236916 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 795 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007617.43553 | 2095823.37695 | 37.7351624451822 | -122.416089643819 | (37.7351624451822, -122.416089643819) | 2 | 7 | 7 | 28859 | 2 | |||
192059 | 235867 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 623 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009867.20841 | 2105208.25482 | 37.7610574909314 | -122.408973285988 | (37.7610574909314, -122.408973285988) | 2 | 4 | 8 | 28859 | 19 | |||
192034 | 217922 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 205 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996559.31007 | 2105837.58218 | 37.7620310124479 | -122.455044756717 | (37.7620310124479, -122.455044756717) | 15 | 5 | 11 | 29492 | 12 | |||
192014 | 237856 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 636 30th St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | 2 | 7 | 5 | 63 | 7 | |||
191997 | 61462 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 218 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1984 12:00:00 AM | Permit Number 21404 | 6004121.96374006 | 2107570.66131197 | 37.7672205874505 | -122.429012038182 | (37.7672205874505, -122.429012038182) | 8 | 4 | 5 | 28862 | 3 | ||
191987 | 236683 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4417 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001196.10514 | 2101120.7901 | 37.7493447583755 | -122.438669921606 | (37.7493447583755, -122.438669921606) | 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) );