trees
4,014 rows where qSpecies_id = 40 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79494 | 102172 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
187812 | 102171 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
61746 | 103815 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | 13 | 9 | 10 | 28858 | 21 | ||
188159 | 103814 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.7872896682178 | -122.41980969397 | (37.7872896682178, -122.41980969397) | 13 | 9 | 10 | 28858 | 21 | ||
134437 | 106104 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X HARTFORD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 6002644 | 2105609 | 37.7617505722061 | -122.433983855891 | (37.7617505722061, -122.433983855891) | 15 | 4 | 5 | 28862 | 3 | |||
81435 | 103790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
123507 | 103789 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
189169 | 103788 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
54353 | 92795 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 999 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 52022 | 6012811.72806 | 2102960.97452 | 37.7550514540675 | -122.398631693097 | (37.7550514540675, -122.398631693097) | 10 | 3 | 8 | 28856 | 29 | ||
81146 | 50013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 999 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 2 | Permit Number 52022 | 6012813.23846 | 2102916.22313 | 37.7549286606329 | -122.398623329429 | (37.7549286606329, -122.398623329429) | 10 | 3 | 8 | 28856 | 29 | ||
155160 | 50012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 999 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3 | Permit Number 52022 | 6012815.30679 | 2102898.98068 | 37.7548814318474 | -122.398614966606 | (37.7548814318474, -122.398614966606) | 10 | 3 | 8 | 28856 | 29 | ||
36730 | 88755 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
41061 | 88754 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
61126 | 88757 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
67107 | 88756 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
168965 | 88758 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
34039 | 214586 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Lurline St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991797.24282 | 2105160.13834 | 37.7598965875689 | -122.471465380821 | (37.7598965875689, -122.471465380821) | 1 | 8 | 4 | 56 | 12 | |||
116976 | 214588 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Lurline St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991798.55182 | 2105130.62844 | 37.7598156368994 | -122.471458703373 | (37.7598156368994, -122.471458703373) | 1 | 8 | 4 | 56 | 12 | |||
129583 | 214589 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Lurline St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991796.94128 | 2105115.28006 | 37.7597734011291 | -122.471463154997 | (37.7597734011291, -122.471463154997) | 1 | 8 | 4 | 56 | 12 | |||
144985 | 214587 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Lurline St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991795.61852 | 2105144.1496 | 37.7598525927434 | -122.471469833373 | (37.7598525927434, -122.471469833373) | 1 | 8 | 4 | 56 | 12 | |||
23030 | 135979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.7882275541095 | -122.419939904112 | (37.7882275541095, -122.419939904112) | 13 | 9 | 10 | 28858 | 21 | ||
60351 | 135978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.7882128537759 | -122.420019889812 | (37.7882128537759, -122.420019889812) | 13 | 9 | 10 | 28858 | 21 | ||
20340 | 238038 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Elgin Park | 3 | : | Tree | Private 2 | 5 | Width 2ft | 6005844.52457 | 2108573.0044 | 37.7700701367551 | -122.423125198471 | (37.7700701367551, -122.423125198471) | 8 | 2 | 5 | 28853 | 19 | |||
34005 | 238037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Elgin Park | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6005845.91582 | 2108560.69634 | 37.770036420279 | -122.423119511166 | (37.770036420279, -122.423119511166) | 8 | 2 | 5 | 28853 | 19 | |||
109043 | 103832 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
122072 | 103833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
133115 | 103831 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
60607 | 103806 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006930.58351 | 2114841.83487 | 37.7873440601297 | -122.419813414468 | (37.7873440601297, -122.419813414468) | 13 | 9 | 10 | 28858 | 21 | ||
89069 | 103803 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.48816 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | 13 | 9 | 10 | 28858 | 21 | ||
100395 | 103805 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006953.73656 | 2114843.50125 | 37.7873499398897 | -122.41973342787 | (37.7873499398897, -122.41973342787) | 13 | 9 | 10 | 28858 | 21 | ||
146672 | 103804 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006974.73956 | 2114845.21209 | 37.7873558205593 | -122.419660883156 | (37.7873558205593, -122.419660883156) | 13 | 9 | 10 | 28858 | 21 | ||
47904 | 23041 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 987 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1994 12:00:00 AM | 12 | 3X3 | 6006352.9755 | 2103862.85209 | 37.7571658456457 | -122.421031987753 | (37.7571658456457, -122.421031987753) | 2 | 4 | 7 | 28859 | 19 | ||
145154 | 26851 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 987 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6006383.06935 | 2103878.37852 | 37.7572101739855 | -122.420929013752 | (37.7572101739855, -122.420929013752) | 2 | 4 | 7 | 28859 | 19 | |||
16871 | 83424 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 987 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012206.17554 | 2103813.08601 | 37.7573574093248 | -122.400785742066 | (37.7573574093248, -122.400785742066) | 10 | 3 | 8 | 28856 | 29 | |||
112928 | 214783 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 984 Portola Dr | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 5996077.08302 | 2098544.42751 | 37.7419781641671 | -122.456185254462 | (37.7419781641671, -122.456185254462) | 1 | 7 | 4 | 59 | 40 | |||
11733 | 135934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997041.86737 | 2116129.80097 | 37.7903184311097 | -122.454119176269 | (37.7903184311097, -122.454119176269) | 11 | 6 | 1 | 54 | 31 | |||
28964 | 135935 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997049.33252 | 2116083.66446 | 37.7901921806791 | -122.45409001394 | (37.7901921806791, -122.45409001394) | 11 | 6 | 1 | 54 | 31 | |||
69397 | 135936 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997050.12682 | 2116069.05064 | 37.7901521005919 | -122.454086209825 | (37.7901521005919, -122.454086209825) | 11 | 6 | 1 | 54 | 31 | |||
87651 | 135933 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997039.44005 | 2116145.17864 | 37.7903605148824 | -122.45412868571 | (37.7903605148824, -122.45412868571) | 11 | 6 | 1 | 54 | 31 | |||
25525 | 214765 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993613.7342 | 2101408.96874 | 37.7497017595309 | -122.464910643325 | (37.7497017595309, -122.464910643325) | 1 | 8 | 4 | 29491 | 40 | |||
120483 | 135980 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | 13 | 9 | 10 | 28858 | 21 | ||
125611 | 135981 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006885.98637 | 2115183.79121 | 37.7882804756017 | -122.419991987453 | (37.7882804756017, -122.419991987453) | 13 | 9 | 10 | 28858 | 21 | ||
130957 | 135982 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006867.71438 | 2115184.16614 | 37.7882804756098 | -122.420055232261 | (37.7882804756098, -122.420055232261) | 13 | 9 | 10 | 28858 | 21 | ||
156339 | 239545 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007158.69196 | 2097383.79915 | 37.7394212162163 | -122.417786261644 | (37.7394212162163, -122.417786261644) | 2 | 7 | 7 | 28859 | 2 | |||
83992 | 136008 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 979 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008203.73321 | 2119954.656 | 37.8014542449694 | -122.415770737051 | (37.8014542449694, -122.415770737051) | 5 | 1 | 10 | 308 | 32 | |||
151641 | 237378 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 979 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009172.53349 | 2103497.32984 | 37.7563207410375 | -122.411255009913 | (37.7563207410375, -122.411255009913) | 2 | 4 | 7 | 28859 | 19 | |||
153049 | 237377 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 979 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009171.61853 | 2103483.06464 | 37.7562815207028 | -122.411257166497 | (37.7562815207028, -122.411257166497) | 2 | 4 | 7 | 28859 | 19 | |||
13155 | 196442 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 971 Kansas St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 5ft | 6011633.49107 | 2103859.13783 | 37.7574518984069 | -122.402769561075 | (37.7574518984069, -122.402769561075) | 10 | 3 | 8 | 28856 | 29 | |||
152574 | 237379 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 971 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009173.1624 | 2103512.84287 | 37.7563633715887 | -122.411253930735 | (37.7563633715887, -122.411253930735) | 2 | 4 | 7 | 28859 | 19 | |||
88700 | 238098 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 970 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009393.96902 | 2103533.4588 | 37.7564323594785 | -122.410491757086 | (37.7564323594785, -122.410491757086) | 2 | 4 | 7 | 28859 | 19 | |||
21191 | 124157 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 970 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995831.42602 | 2112225.32122 | 37.7795282934849 | -122.45802450638 | (37.7795282934849, -122.45802450638) | 11 | 6 | 2 | 54 | 16 | |||
87296 | 196508 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 97 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016637.34398 | 2094986.73553 | 37.7333682203685 | -122.384845988159 | (37.7333682203685, -122.384845988159) | 10 | 3 | 8 | 58 | 1 | |||
140253 | 237186 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 967 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004411.68951 | 2103282.70615 | 37.7554632788353 | -122.42770437188 | (37.7554632788353, -122.42770437188) | 2 | 4 | 5 | 28862 | 22 | |||
133521 | 93018 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 963 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2010 12:00:00 AM | 3x3 | Permit Number 53140 | 6006134 | 2121397 | 37.805297983444 | -122.423035527254 | (37.805297983444, -122.423035527254) | 5 | 1 | 1 | 28858 | 32 | ||
44187 | 214772 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 96 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993626.401 | 2101411.46451 | 37.7497093426138 | -122.464867022618 | (37.7497093426138, -122.464867022618) | 1 | 8 | 4 | 29491 | 40 | |||
174057 | 44031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 96 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52444 | 6007775.95033 | 2109430.42042 | 37.7725332035812 | -122.416505148587 | (37.7725332035812, -122.416505148587) | 8 | 2 | 9 | 28853 | 19 | |
53312 | 96033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767672 | 6008167.44383 | 2115805.7111 | 37.7900602294563 | -122.415602393833 | (37.7900602294563, -122.415602393833) | 13 | 1 | 10 | 28858 | 21 |
167380 | 214520 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 955 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992757.19823 | 2106588.47757 | 37.7638739184803 | -122.468249300883 | (37.7638739184803, -122.468249300883) | 1 | 8 | 11 | 56 | 12 | |||
119479 | 238097 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 954 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009388.54341 | 2103614.69928 | 37.7566551233629 | -122.410516257342 | (37.7566551233629, -122.410516257342) | 2 | 4 | 7 | 28859 | 19 | |||
188589 | 66638 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 952-956 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | Permit Number 772673 | 6010185.68090669 | 2103671.40205978 | 37.7568554734734 | -122.407763452505 | (37.7568554734734, -122.407763452505) | 2 | 4 | 7 | 28859 | 19 | |
48437 | 237159 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 952 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010190.97123 | 2103671.66986 | 37.7568565049508 | -122.407745175399 | (37.7568565049508, -122.407745175399) | 2 | 4 | 7 | 28859 | 19 | |||
75741 | 239464 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 951 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997205.01484 | 2107160.84774 | 37.765701384931 | -122.452907043925 | (37.765701384931, -122.452907043925) | 15 | 5 | 11 | 29492 | 12 | |||
183191 | 51229 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 951 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47595 | 5997196.98951601 | 2107229.04702326 | 37.7658881828434 | -122.452939724819 | (37.7658881828434, -122.452939724819) | 15 | 5 | 11 | 29492 | 12 | ||
104181 | 98790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
146437 | 122332 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2112291 | 37.7797254357482 | -122.45701712634 | (37.7797254357482, -122.45701712634) | 11 | 6 | 2 | 54 | 16 | ||||
73001 | 98796 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.408747227007 | (37.7940014192822, -122.408747227007) | 3 | 1 | 10 | 28857 | 4 | |
192369 | 238167 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003106.03405 | 2102661.1372 | 37.7536826553521 | -122.432175338843 | (37.7536826553521, -122.432175338843) | 2 | 4 | 5 | 28862 | 22 | |||
150626 | 237190 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004359.56384 | 2103198.79437 | 37.755229928124 | -122.427878659579 | (37.755229928124, -122.427878659579) | 2 | 4 | 5 | 28862 | 22 | |||
152464 | 237189 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004351.71589 | 2103282.1102 | 37.7554582498219 | -122.427911736635 | (37.7554582498219, -122.427911736635) | 2 | 4 | 5 | 28862 | 22 | |||
124350 | 124153 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996057.73725 | 2112257.8824 | 37.7796306981474 | -122.457243960242 | (37.7796306981474, -122.457243960242) | 11 | 6 | 2 | 54 | 16 | |||
166496 | 124154 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996038.47697 | 2112254.19163 | 37.7796194580787 | -122.457310322373 | (37.7796194580787, -122.457310322373) | 11 | 6 | 2 | 54 | 16 | |||
129293 | 47028 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45023 | 6002341.57437818 | 2108786.87208676 | 37.770459063814 | -122.435257139527 | (37.770459063814, -122.435257139527) | 15 | 5 | 5 | 29492 | 9 | ||
59243 | 179074 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001547.28208 | 2092126.29035 | 37.7246679234714 | -122.436811752268 | (37.7246679234714, -122.436811752268) | 9 | 7 | 6 | 28861 | 25 | |||
34456 | 213358 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990836.79794 | 2095256.57076 | 37.7326483517269 | -122.474064462004 | (37.7326483517269, -122.474064462004) | 1 | 8 | 4 | 64 | 40 | |||
126609 | 213359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 Beachmont Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5990836.58141 | 2095246.30718 | 37.7326201579899 | -122.474064462004 | (37.7326201579899, -122.474064462004) | 1 | 8 | 4 | 64 | 40 | |||
37177 | 250524 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.45058 | 2115374.99193 | 37.7877049922276 | -122.486435864334 | (37.7877049922276, -122.486435864334) | 11 | 6 | 1 | 55 | 33 | |||
54488 | 250523 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.92853 | 2115397.50584 | 37.7877668368263 | -122.48643586434 | (37.7877668368263, -122.48643586434) | 11 | 6 | 1 | 55 | 33 | |||
131806 | 250521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.5238 | 2115445.0256 | 37.7878972888638 | -122.486440754852 | (37.7878972888638, -122.486440754852) | 11 | 6 | 1 | 55 | 33 | |||
72488 | 5816 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 949 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6000363.39173 | 2099612.72886 | 37.745156576909 | -122.441441255331 | (37.745156576909, -122.441441255331) | 2 | 7 | 5 | 63 | 22 | ||
49052 | 179025 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008937.54219 | 2090376.09955 | 37.7202795151651 | -122.411140883254 | (37.7202795151651, -122.411140883254) | 9 | 3 | 7 | 309 | 28 | |||
61781 | 179022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008892.67807 | 2090361.86972 | 37.7202379269127 | -122.411294959597 | (37.7202379269127, -122.411294959597) | 9 | 3 | 7 | 309 | 28 | |||
129435 | 179024 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008925.8511 | 2090372.55179 | 37.7202691181059 | -122.411181045172 | (37.7202691181059, -122.411181045172) | 9 | 3 | 7 | 309 | 28 | |||
190138 | 179023 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008910.54006 | 2090367.60541 | 37.7202546776964 | -122.411233621349 | (37.7202546776964, -122.411233621349) | 9 | 3 | 7 | 309 | 28 | |||
31046 | 214521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2014 12:00:00 AM | 2 | Width 3ft | 5992776.19936 | 2106588.69627 | 37.7638756163819 | -122.468183598193 | (37.7638756163819, -122.468183598193) | 1 | 8 | 11 | 56 | 12 | ||
2772 | 108460 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 944 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773734 | 6010189.19593 | 2103716.38941 | 37.7569791954421 | -122.407754468243 | (37.7569791954421, -122.407754468243) | 2 | 4 | 7 | 28859 | 19 |
147086 | 237157 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 944 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010187.69815 | 2103705.30637 | 37.7569486800479 | -122.407758866688 | (37.7569486800479, -122.407758866688) | 2 | 4 | 7 | 28859 | 19 | |||
35613 | 238164 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 942 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003096.31743 | 2102785.90306 | 37.7540246819046 | -122.432217850697 | (37.7540246819046, -122.432217850697) | 2 | 4 | 5 | 28862 | 22 | |||
56562 | 213680 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6001486.95332 | 2094958.62798 | 37.7324414465191 | -122.437223005055 | (37.7324414465191, -122.437223005055) | 9 | 7 | 5 | 63 | 40 | |||
159960 | 91940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 939 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992887.176206 | 2106601.263166 | 37.763916530494 | -122.467800680148 | (37.763916530494, -122.467800680148) | 1 | 8 | 11 | 56 | 12 | ||
166293 | 214522 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 939 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992798.79184 | 2106588.46836 | 37.7638762953807 | -122.468105441723 | (37.7638762953807, -122.468105441723) | 1 | 8 | 11 | 56 | 12 | |||
136221 | 237380 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 937 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009162.70546 | 2103687.87631 | 37.7568433874198 | -122.411302459066 | (37.7568433874198, -122.411302459066) | 2 | 4 | 7 | 28859 | 19 | |||
124087 | 213293 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 930 Capitol Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995051.99009 | 2090130.06095 | 37.7188154620373 | -122.45912052741 | (37.7188154620373, -122.45912052741) | 9 | 8 | 6 | 28861 | 24 | |||
161883 | 214523 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 929 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992854.95804 | 2106590.62529 | 37.7638854612741 | -122.467911338361 | (37.7638854612741, -122.467911338361) | 1 | 8 | 11 | 56 | 12 | |||
124796 | 37808 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 925 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 14 | Permit Number 40128 | 6009009.75323 | 2091360.17391 | 37.7229856264714 | -122.410960741867 | (37.7229856264714, -122.410960741867) | 9 | 3 | 7 | 309 | 28 | |
45181 | 91941 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 925 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992928.667696 | 2106602.68442 | 37.7639228286278 | -122.467657278128 | (37.7639228286278, -122.467657278128) | 1 | 8 | 11 | 56 | 12 | ||
18789 | 71443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 924 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012090.03782 | 2119001.59006 | 37.7990550614973 | -122.402255254071 | (37.7990550614973, -122.402255254071) | 3 | 1 | 10 | 28860 | 6 | |||
37795 | 95715 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 922 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767470 | 6005041.96775 | 2091992.09959 | 37.7244974623786 | -122.424721511311 | (37.7244974623786, -122.424721511311) | 9 | 7 | 6 | 28861 | 5 |
85022 | 214524 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 921 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992892.31129 | 2106589.71592 | 37.7638851213132 | -122.467782079696 | (37.7638851213132, -122.467782079696) | 1 | 8 | 11 | 56 | 12 | |||
108468 | 214773 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 92 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993651.47421 | 2101409.8267 | 37.7497062912147 | -122.464780200252 | (37.7497062912147, -122.464780200252) | 1 | 8 | 4 | 29491 | 40 | |||
116656 | 62166 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 92 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | 21 | Permit Number 23136 | 5999904.31715 | 2091941.24104 | 37.7240663075915 | -122.442477978483 | (37.7240663075915, -122.442477978483) | 9 | 7 | 6 | 28861 | 25 |
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) );