trees
6,714 rows where qSpecies_id = 7 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
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 | ||||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
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 | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
106448 | 44743 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 306 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 5 | Permit Number 43861 | 5992021.82053 | 2086414.86847 | 37.7084397758389 | -122.469324250627 | (37.7084397758389, -122.469324250627) | 9 | 8 | 4 | 64 | 24 | |
188142 | 44742 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 276 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 4 | Permit Number 43860 | 5992023.15498 | 2086637.27235 | 37.7090505207416 | -122.469335815893 | (37.7090505207416, -122.469335815893) | 9 | 8 | 4 | 64 | 24 | |
34501 | 178750 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009169.8221 | 2086336.97845 | 37.7092019449876 | -122.410052964391 | (37.7092019449876, -122.410052964391) | 9 | 7 | 8 | 309 | 39 | |||
154565 | 178844 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Tomaso Ct | 1 | : | Tree | Private 2 | 16 | Width 2ft | 6009171.05644 | 2086338.49099 | 37.7092061672978 | -122.410048805012 | (37.7092061672978, -122.410048805012) | 9 | 7 | 8 | 309 | 39 | |||
100298 | 73606 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 40 Rhine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1995 12:00:00 AM | 4 | 5994431.82308 | 2086668.63726 | 37.7092755401168 | -122.461013433922 | (37.7092755401168, -122.461013433922) | 9 | 8 | 6 | 28861 | 25 | ||
4921 | 71593 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994443.94493 | 2086683.28618 | 37.7093164601484 | -122.46097260021 | (37.7093164601484, -122.46097260021) | 9 | 8 | 6 | 28861 | 25 | |||
91958 | 178753 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 288 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008616.33006 | 2086415.65366 | 37.7093869328198 | -122.411971481801 | (37.7093869328198, -122.411971481801) | 9 | 7 | 8 | 309 | 39 | |||
43859 | 178848 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 284 Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008617.09448 | 2086417.42045 | 37.7093918269511 | -122.411968964603 | (37.7093918269511, -122.411968964603) | 9 | 7 | 8 | 309 | 39 | |||
5910 | 24288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
172914 | 178843 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 316 Naylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002755.16684 | 2086552.83016 | 37.7094330059866 | -122.432238395683 | (37.7094330059866, -122.432238395683) | 9 | 7 | 6 | 28861 | 5 | |||
135026 | 178752 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 276 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008629.54675 | 2086454.27777 | 37.7094937282293 | -122.411928530185 | (37.7094937282293, -122.411928530185) | 9 | 7 | 8 | 309 | 39 | |||
133610 | 178847 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 272 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008631.68261 | 2086459.28689 | 37.7095076020765 | -122.411921502003 | (37.7095076020765, -122.411921502003) | 9 | 7 | 8 | 309 | 39 | |||
13743 | 31056 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 9 Toyon Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 7 | Permit Number 34808 | 6003244.64588 | 2086572.31488 | 37.7095142480656 | -122.430548065039 | (37.7095142480656, -122.430548065039) | 9 | 7 | 6 | 28861 | 5 | |
162816 | 178705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 980 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5996782.39454 | 2086708.52961 | 37.7095200567877 | -122.452892407466 | (37.7095200567877, -122.452892407466) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||||
147029 | 178751 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 272 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008644.3214 | 2086482.2621 | 37.7095713963714 | -122.411879442491 | (37.7095713963714, -122.411879442491) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
188355 | 178833 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6001567.75342 | 2086664.56423 | 37.7096724055308 | -122.436350277744 | (37.7096724055308, -122.436350277744) | 9 | 7 | 6 | 28861 | 5 | |||
46561 | 44740 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 235 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 5 | Permit Number 43858 | 5992059.17709 | 2086878.10482 | 37.7097138705641 | -122.469228836168 | (37.7097138705641, -122.469228836168) | 9 | 8 | 4 | 64 | 24 | |
41462 | 178834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6001553.31629 | 2086683.73815 | 37.7097242325659 | -122.436401546312 | (37.7097242325659, -122.436401546312) | 9 | 7 | 6 | 28861 | 5 | |||
167855 | 178835 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Drake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001544.78334 | 2086699.50707 | 37.7097670456913 | -122.436432165527 | (37.7097670456913, -122.436432165527) | 9 | 7 | 6 | 28861 | 5 | |||
46408 | 178836 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Drake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001534.96826 | 2086713.04585 | 37.7098036624786 | -122.436467056534 | (37.7098036624786, -122.436467056534) | 9 | 7 | 6 | 28861 | 5 | |||
174872 | 44738 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 224 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 6 | Permit Number 43855 | 5992028.81192 | 2086945.80589 | 37.7098980067533 | -122.469338707219 | (37.7098980067533, -122.469338707219) | 9 | 8 | 4 | 64 | 24 | |
41663 | 69408 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.59804 | 2086768.97979 | 37.7099574510375 | -122.436458512063 | (37.7099574510375, -122.436458512063) | 9 | 7 | 6 | 28861 | 5 | |
183863 | 178837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 981 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001551.41306 | 2086770.97159 | 37.7099636482706 | -122.436414363453 | (37.7099636482706, -122.436414363453) | 9 | 7 | 6 | 28861 | 5 | |||
108453 | 178838 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 981 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001561.30647 | 2086771.17725 | 37.7099647751299 | -122.436380184711 | (37.7099647751299, -122.436380184711) | 9 | 7 | 6 | 28861 | 5 | |||
24451 | 178839 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 921 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6001840.757 | 2086804.78662 | 37.7100729338953 | -122.435416754499 | (37.7100729338953, -122.435416754499) | 9 | 7 | 6 | 28861 | 5 | |||
13656 | 78518 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Laura St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997355.58596 | 2086978.87375 | 37.7102951905332 | -122.450930851174 | (37.7102951905332, -122.450930851174) | 9 | 7 | 6 | 28861 | 25 | |||
5566 | 78781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997342.70536 | 2086993.54413 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | 9 | 7 | 6 | 28861 | 25 | |||
186144 | 178739 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 416 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012199.66481 | 2086699.29311 | 37.7103661434655 | -122.39960671289 | (37.7103661434655, -122.39960671289) | 10 | 3 | 8 | 309 | 1 | |||
121457 | 178842 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 856 Prague St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | |||
72436 | 178841 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 856 Prague St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002067.27688 | 2086921.00065 | 37.7104048943477 | -122.434642162998 | (37.7104048943477, -122.434642162998) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
33603 | 178755 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008316.59647 | 2086843.35831 | 37.7105445006064 | -122.413037635286 | (37.7105445006064, -122.413037635286) | 9 | 7 | 8 | 309 | 39 | |||
33040 | 178754 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 27 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008327.5198 | 2086871.77855 | 37.7106231499219 | -122.413001889918 | (37.7106231499219, -122.413001889918) | 9 | 7 | 8 | 309 | 39 | |||
11820 | 78914 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 219 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | 9 | 7 | 6 | 28861 | 5 | |||
1128 | 178845 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 Sawyer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007634.8415 | 2086934.39681 | 37.7107561785306 | -122.415400376427 | (37.7107561785306, -122.415400376427) | 9 | 7 | 8 | 309 | 39 | |||
75080 | 84187 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50696 | 6007633.86618 | 2086936.80805 | 37.7107627444765 | -122.415403917956 | (37.7107627444765, -122.415403917956) | 9 | 7 | 8 | 309 | 39 | |
9340 | 78715 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008812.7369 | 2086938.04091 | 37.7108323187195 | -122.411329543927 | (37.7108323187195, -122.411329543927) | 9 | 7 | 8 | 309 | 39 | |||
13649 | 178696 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1121 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008480.05498 | 2086950.03889 | 37.7108465981642 | -122.412480221081 | (37.7108465981642, -122.412480221081) | 9 | 7 | 8 | 309 | 39 | |||
73742 | 65746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 252 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | Permit Number 28705 | 6000865.93587078 | 2087131.69490372 | 37.7109151403091 | -122.438809330108 | (37.7109151403091, -122.438809330108) | 9 | 7 | 6 | 28861 | 5 | ||
128731 | 178832 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 26 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002753.4939 | 2087126.65044 | 37.71100849683 | -122.43228513165 | (37.71100849683, -122.43228513165) | 9 | 7 | 6 | 28861 | 5 | |||
191050 | 178697 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 170 Lawrence Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 5996822.29762 | 2087264.10807 | 37.7110478340594 | -122.452794569318 | (37.7110478340594, -122.452794569318) | 9 | 7 | 6 | 28861 | 25 | |||
164218 | 65315 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1989 12:00:00 AM | 18 | Permit Number 28137 | 6013067.51643 | 2086945.434 | 37.7110903360125 | -122.39662445846 | (37.7110903360125, -122.39662445846) | 10 | 3 | 8 | 309 | 1 | ||
88023 | 178738 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 88 Gillette Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013102.20794 | 2086955.43637 | 37.7111197312489 | -122.39650525601 | (37.7111197312489, -122.39650525601) | 10 | 3 | 8 | 309 | 1 | |||
60314 | 178737 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013141.93389 | 2086956.08513 | 37.7111237233427 | -122.396367997898 | (37.7111237233427, -122.396367997898) | 10 | 3 | 8 | 309 | 1 | |||
174383 | 178840 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1065 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002119.38667 | 2087187.39371 | 37.7111393094924 | -122.434481095339 | (37.7111393094924, -122.434481095339) | 9 | 7 | 6 | 28861 | 5 | |||
23123 | 212611 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 241 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994544.18385 | 2087742.4739 | 37.7122305082008 | -122.460702867445 | (37.7122305082008, -122.460702867445) | 9 | 8 | 6 | 28861 | 24 | |||
70479 | 178704 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Rae Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998308.33595 | 2087754.71225 | 37.7124799639485 | -122.447693779246 | (37.7124799639485, -122.447693779246) | 9 | 7 | 6 | 28861 | 25 | |||
190799 | 178703 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Rae Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998317.89725 | 2087761.99008 | 37.7125004936668 | -122.447661256171 | (37.7125004936668, -122.447661256171) | 9 | 7 | 6 | 28861 | 25 | |||
68721 | 178702 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Rae Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998336.16892 | 2087781.41779 | 37.7125548819847 | -122.447599501525 | (37.7125548819847, -122.447599501525) | 9 | 7 | 6 | 28861 | 25 | |||
102506 | 178701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Rae Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998344.49014 | 2087790.45997 | 37.7125801853098 | -122.447571391401 | (37.7125801853098, -122.447571391401) | 9 | 7 | 6 | 28861 | 25 | |||
110244 | 178700 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Rae Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998352.64125 | 2087797.95549 | 37.7126012321305 | -122.447543757946 | (37.7126012321305, -122.447543757946) | 9 | 7 | 6 | 28861 | 25 | |||
3097 | 52514 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
55937 | 52515 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
56240 | 52518 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
67749 | 52517 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
148271 | 52516 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
31528 | 178735 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 110 Newton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000958.61329 | 2087891.23319 | 37.7130059360373 | -122.438543401379 | (37.7130059360373, -122.438543401379) | 9 | 7 | 6 | 28861 | 5 | |||
171879 | 178734 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 110 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000949.06967 | 2087917.1354 | 37.7130765148503 | -122.438578241996 | (37.7130765148503, -122.438578241996) | 9 | 7 | 6 | 28861 | 5 | |||
31436 | 31009 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
167129 | 31008 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
46143 | 178733 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Morse St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 1ft | 6000880.0864 | 2087963.64183 | 37.7132002867365 | -122.438820001354 | (37.7132002867365, -122.438820001354) | 9 | 7 | 6 | 28861 | 5 | |||
174108 | 178736 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 248 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012387.77571 | 2087731.31879 | 37.713210365434 | -122.39902894795 | (37.713210365434, -122.39902894795) | 10 | 3 | 8 | 309 | 1 | |||
37576 | 178732 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Morse St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 1ft | 6000912.22914 | 2087974.06631 | 37.7132307386797 | -122.438709651846 | (37.7132307386797, -122.438709651846) | 9 | 7 | 6 | 28861 | 5 | |||
4910 | 65716 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 98 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 7 | 3x3 | Permit Number 28648 | 6000919.98791 | 2088014.07766 | 37.7133410423274 | -122.438685700186 | (37.7133410423274, -122.438685700186) | 9 | 7 | 6 | 28861 | 5 |
105098 | 212668 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 162 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992987.49956 | 2088299.56272 | 37.7136704541029 | -122.466123641711 | (37.7136704541029, -122.466123641711) | 9 | 8 | 6 | 64 | 24 | |||
87138 | 48580 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 170 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45894 | 5992735.0311487 | 2088323.3092015 | 37.7137210870883 | -122.466997982048 | (37.7137210870883, -122.466997982048) | 9 | 8 | 6 | 64 | 24 | ||
29862 | 48581 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 162 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45895 | 5992994.26817447 | 2088334.73866608 | 37.7137674293264 | -122.466102801731 | (37.7137674293264, -122.466102801731) | 9 | 8 | 6 | 64 | 24 | ||
85773 | 62994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 121 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1986 12:00:00 AM | 1 | Permit Number 23395 | 5991750.67961 | 2088373.72786 | 37.7138026589318 | -122.470403898426 | (37.7138026589318, -122.470403898426) | 9 | 8 | 6 | 64 | 24 | ||
60978 | 178699 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Sala Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5999039.32435 | 2088222.29438 | 37.7138055898272 | -122.44520086393 | (37.7138055898272, -122.44520086393) | 9 | 7 | 6 | 28861 | 25 | |||
130100 | 178698 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Sala Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 5999028.57689 | 2088233.45107 | 37.7138356100938 | -122.445238812629 | (37.7138356100938, -122.445238812629) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
15833 | 65712 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 52 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 10 | Permit Number 28641 | 6000856.2772 | 2088212.06754 | 37.7138810537462 | -122.438920085998 | (37.7138810537462, -122.438920085998) | 9 | 7 | 6 | 28861 | 5 | |
15164 | 70910 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 45 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000896.54528 | 2088212.43618 | 37.7138843569546 | -122.43878093122 | (37.7138843569546, -122.43878093122) | 9 | 7 | 6 | 28861 | 5 | |||
151063 | 84132 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 332 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50694 | 6008018.96296 | 2088075.22634 | 37.713910242141 | -122.41415342054 | (37.713910242141, -122.41415342054) | 9 | 7 | 8 | 309 | 39 | |
17858 | 74088 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000890.32413 | 2088231.91583 | 37.7139374897944 | -122.438803828836 | (37.7139374897944, -122.438803828836) | 9 | 7 | 6 | 28861 | 5 | |||
9561 | 73853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000885.5664 | 2088247.40697 | 37.713979754329 | -122.438821382721 | (37.713979754329, -122.438821382721) | 9 | 7 | 6 | 28861 | 5 | |||
18455 | 70117 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 25 Newton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000875.39739 | 2088278.84235 | 37.7140654903181 | -122.438858781914 | (37.7140654903181, -122.438858781914) | 9 | 7 | 6 | 28861 | 5 | |||
7370 | 78746 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 355 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009102.50426 | 2088111.28549 | 37.7140700552715 | -122.410410826197 | (37.7140700552715, -122.410410826197) | 9 | 7 | 8 | 309 | 39 | |||
49748 | 212610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 278 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994199.47136 | 2088424.58434 | 37.7140835828601 | -122.461943718748 | (37.7140835828601, -122.461943718748) | 9 | 8 | 6 | 28861 | 24 | |||
127034 | 48564 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 278 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45983 | 5994240.83855888 | 2088432.11877754 | 37.7141066521182 | -122.461801284944 | (37.7141066521182, -122.461801284944) | 9 | 8 | 6 | 28861 | 24 | ||
29142 | 35866 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 963 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 5 | Permit Number 39078 | 6002010.96914 | 2088348.68943 | 37.7143218168851 | -122.434938810705 | (37.7143218168851, -122.434938810705) | 9 | 7 | 6 | 28861 | 5 | |
188230 | 178730 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 38 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000522.25708 | 2088403.46522 | 37.7143875788973 | -122.440088297264 | (37.7143875788973, -122.440088297264) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );