trees
331 rows where qSpecies_id = 166 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177383 | 66146 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1870 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1990 12:00:00 AM | 7 | Permit Number 29213 | 6000296.96947 | 2121326.31343 | 37.8047727901033 | -122.443230173234 | (37.8047727901033, -122.443230173234) | 13 | 9 | 1 | 57 | 17 | ||
91008 | 132141 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2200 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000126.69281 | 2120608.21837 | 37.8027913830869 | -122.443767809531 | (37.8027913830869, -122.443767809531) | 13 | 9 | 1 | 57 | 17 | |||
91888 | 65834 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2222 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 6 | Permit Number 28824 | 6000082.60671 | 2120602.00378 | 37.8027718048421 | -122.443919922685 | (37.8027718048421, -122.443919922685) | 13 | 9 | 1 | 57 | 17 | ||
50359 | 65836 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2226 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 5 | Permit Number 28826 | 6000059.65641 | 2120598.32121 | 37.8027603843422 | -122.443999077409 | (37.8027603843422, -122.443999077409) | 13 | 9 | 1 | 57 | 17 | ||
182666 | 132140 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 3500 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000293.03913 | 2120313.27667 | 37.8019910386216 | -122.443170972674 | (37.8019910386216, -122.443170972674) | 13 | 9 | 1 | 57 | 17 | |||
173399 | 62425 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2190 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 7 | Permit Number 28803 | 6000367.76926 | 2120295.99012 | 37.8019478351817 | -122.442911129744 | (37.8019478351817, -122.442911129744) | 13 | 9 | 1 | 57 | 17 | |
4456 | 132139 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 99 Moulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002898.54088 | 2119398.05033 | 37.7996262865921 | -122.434089249929 | (37.7996262865921, -122.434089249929) | 13 | 9 | 1 | 57 | 17 | |||
22720 | 101293 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1573 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006029.58816 | 2118260.54244 | 37.7966801777065 | -122.42317377447 | (37.7966801777065, -122.42317377447) | 13 | 9 | 10 | 28858 | 32 | |||
90470 | 23459 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2290X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | Permit Number 769634 | 6005952.25741 | 2118257.88317 | 37.7966685117079 | -122.423441167528 | (37.7966685117079, -122.423441167528) | 13 | 9 | 10 | 28858 | 32 | ||
176973 | 101292 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1573 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006005.37071 | 2118256.53367 | 37.7966678039418 | -122.423257287321 | (37.7966678039418, -122.423257287321) | 13 | 9 | 10 | 28858 | 32 | |||
64894 | 33283 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1517 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 3 | Permit Number 37446 | 6008392.97125 | 2117690.44353 | 37.7952479165022 | -122.414955538493 | (37.7952479165022, -122.414955538493) | 5 | 1 | 10 | 28858 | 21 | |
28563 | 33284 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1517 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51277 | 6008395.56604 | 2117667.22147 | 37.7951843002637 | -122.414944915675 | (37.7951843002637, -122.414944915675) | 5 | 1 | 10 | 28858 | 21 | |
54896 | 132159 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2712 Steiner St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 6002156.11084 | 2117482.383 | 37.7943242003589 | -122.436521134556 | (37.7943242003589, -122.436521134556) | 13 | 9 | 1 | 29490 | 27 | |||
119634 | 132158 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2712 Steiner St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6002157.9755 | 2117472.75324 | 37.7942978654946 | -122.436513993051 | (37.7942978654946, -122.436513993051) | 13 | 9 | 1 | 29490 | 27 | |||
161668 | 132157 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2712 Steiner St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6002161.41755 | 2117456.24016 | 37.7942527204522 | -122.436500900709 | (37.7942527204522, -122.436500900709) | 13 | 9 | 1 | 29490 | 27 | |||
151116 | 96615 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1224 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008996.31071 | 2117161.4041 | 37.7938291883275 | -122.412830459354 | (37.7938291883275, -122.412830459354) | 3 | 1 | 10 | 28857 | 21 | |
127932 | 96614 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1224 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008998.07345 | 2117142.60049 | 37.7937776571604 | -122.412823030064 | (37.7937776571604, -122.412823030064) | 3 | 1 | 10 | 28857 | 21 | |
38520 | 18883 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2323 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003550.92493 | 2115900.91625 | 37.7900610577251 | -122.431581959853 | (37.7900610577251, -122.431581959853) | 13 | 9 | 1 | 29490 | 27 | ||
90723 | 112348 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 50 Perine Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6002110.93793 | 2115571.44216 | 37.7890746830929 | -122.436540595874 | (37.7890746830929, -122.436540595874) | 13 | 6 | 1 | 29490 | 27 | |||
31105 | 138407 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2445 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6002075.8939 | 2115001.0109 | 37.7875064337018 | -122.436620996287 | (37.7875064337018, -122.436620996287) | 13 | 6 | 11 | 29490 | 27 | |||
6484 | 17950 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2475 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6002060.75972 | 2114997.16684 | 37.7874950188452 | -122.436673082148 | (37.7874950188452, -122.436673082148) | 13 | 6 | 11 | 29490 | 27 | |||
62100 | 17949 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2475 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6002044.53862 | 2114995.39484 | 37.7874892315411 | -122.436729076891 | (37.7874892315411, -122.436729076891) | 13 | 6 | 11 | 29490 | 27 | |||
174713 | 17948 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2475 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6002031.27574 | 2114994.27895 | 37.787485413843 | -122.436774883786 | (37.787485413843, -122.436774883786) | 13 | 6 | 11 | 29490 | 27 | |||
181481 | 139023 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2511 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000454.7447 | 2114081.9995 | 37.7848908066545 | -122.442163834685 | (37.7848908066545, -122.442163834685) | 15 | 6 | 11 | 29490 | 13 | |||
138735 | 139021 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2557 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000404.6376 | 2114075.0402 | 37.7848688424651 | -122.442336688766 | (37.7848688424651, -122.442336688766) | 15 | 6 | 11 | 29490 | 13 | |||
119305 | 139020 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2557 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000390.0231 | 2114072.2564 | 37.7848603658988 | -122.442387050125 | (37.7848603658988, -122.442387050125) | 15 | 6 | 11 | 29490 | 13 | |||
74422 | 139017 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2569 SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000294.6805 | 2114054.8581 | 37.7848071599694 | -122.442715653875 | (37.7848071599694, -122.442715653875) | 15 | 6 | 11 | 29490 | 13 | |||
182342 | 139016 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2569 SUTTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000276.5862 | 2114052.7703 | 37.7848003959002 | -122.442778104076 | (37.7848003959002, -122.442778104076) | 15 | 6 | 11 | 29490 | 13 | |||
69418 | 139015 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2569 SUTTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000259.188 | 2114052.0744 | 37.7847974932802 | -122.442838245979 | (37.7847974932802, -122.442838245979) | 15 | 6 | 11 | 29490 | 13 | |||
145153 | 139013 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2569 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000229.2629 | 2114047.2029 | 37.7847824113212 | -122.442941426751 | (37.7847824113212, -122.442941426751) | 15 | 6 | 11 | 29490 | 13 | |||
38969 | 194415 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 352 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011565.08159 | 2112704.30706 | 37.7817349030809 | -122.403628477474 | (37.7817349030809, -122.403628477474) | 6 | 2 | 9 | 28853 | 34 | |||
129936 | 194416 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 352 Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011538.50656 | 2112682.25434 | 37.7816728669476 | -122.403718862928 | (37.7816728669476, -122.403718862928) | 6 | 2 | 9 | 28853 | 34 | |||
108938 | 194417 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 352 Tehama St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011498.49075 | 2112641.6467 | 37.7815591323857 | -122.403854441123 | (37.7815591323857, -122.403854441123) | 6 | 2 | 9 | 28853 | 34 | |||
7990 | 194420 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 412 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6011221.81037 | 2112380.99989 | 37.7808279961568 | -122.404793272219 | (37.7808279961568, -122.404793272219) | 14 | 2 | 9 | 28853 | 34 | |||
194223 | 14733 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 912X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | |||
77974 | 139825 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 900 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004831 | 2112025 | 37.7794912277556 | -122.426876850808 | (37.7794912277556, -122.426876850808) | 7 | 9 | 11 | 28852 | 41 | |||
138170 | 89380 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1250X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5994772.91396 | 2112159.37755 | 37.7792863553313 | -122.461681542526 | (37.7792863553313, -122.461681542526) | 11 | 6 | 2 | 54 | 11 | ||
44501 | 123786 | Undocumented 4 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1250 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5994756.19271 | 2112157.05976 | 37.7792790287593 | -122.461739219761 | (37.7792790287593, -122.461739219761) | 11 | 6 | 2 | 54 | 11 | |||
31621 | 140028 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 850 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004878.2522 | 2111874.4798 | 37.7790806079305 | -122.426702663449 | (37.7790806079305, -122.426702663449) | 7 | 9 | 11 | 28852 | 41 | |||
150752 | 140013 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 840 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004880.8164 | 2111850.7611 | 37.7790156271835 | -122.426692103329 | (37.7790156271835, -122.426692103329) | 7 | 9 | 11 | 28852 | 41 | |||
27509 | 12287 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 820 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2014 02:37:00 PM | 3 | 4X4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | ||
110491 | 12292 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 830 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | ||
158776 | 254564 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 890X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2002 12:00:00 AM | 3X3 | 6004895.58164 | 2111744.14099 | 37.7787237093276 | -122.426633429967 | (37.7787237093276, -122.426633429967) | 7 | 9 | 11 | 28852 | 41 | |||
175266 | 14739 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 890X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2002 12:00:00 AM | 3 | 4X4 | 6004895.58164 | 2111744.14099 | 37.7787237093276 | -122.426633429967 | (37.7787237093276, -122.426633429967) | 7 | 9 | 11 | 28852 | 41 | ||
33598 | 140011 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 820 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004901.0094 | 2111721.5902 | 37.7786620972536 | -122.426613046979 | (37.7786620972536, -122.426613046979) | 7 | 9 | 11 | 28852 | 41 | |||
78794 | 140010 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 820 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004913.6029 | 2111647.1443 | 37.7784583990483 | -122.426564178697 | (37.7784583990483, -122.426564178697) | 7 | 9 | 11 | 28852 | 41 | |||
66282 | 31859 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 603 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | 8 | 2 | 9 | 28853 | 34 | ||
169467 | 31857 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 603 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | 8 | 2 | 9 | 28853 | 34 | ||
177833 | 31861 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 603 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | 8 | 2 | 9 | 28853 | 34 | ||
65477 | 42213 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 963 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42480 | 6011658.35372103 | 2111289.20991303 | 37.7778545845813 | -122.403206224165 | (37.7778545845813, -122.403206224165) | 14 | 2 | 9 | 28856 | 34 | ||
85578 | 42212 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 963 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42480 | 6011658.35372103 | 2111289.20991303 | 37.7778545845813 | -122.403206224165 | (37.7778545845813, -122.403206224165) | 14 | 2 | 9 | 28856 | 34 | |||
40792 | 141418 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
59505 | 141419 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
122172 | 141408 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
130841 | 141412 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
150588 | 141414 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
180312 | 141410 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
185669 | 141416 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
167137 | 141405 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | 3 | Width 0ft | Permit Number 34950 | 6004899.5578 | 2111091.1041 | 37.7769308549567 | -122.426573161514 | (37.7769308549567, -122.426573161514) | 7 | 9 | 11 | 28852 | 10 | |
178215 | 132145 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004877.00023 | 2111089.96239 | 37.7769264448274 | -122.426651113773 | (37.7769264448274, -122.426651113773) | 7 | 9 | 11 | 28852 | 10 | |||
62193 | 141406 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | 6 | Width 0ft | Permit Number 34950 | 6004860.5862 | 2111087.89 | 37.7769198265662 | -122.426707747337 | (37.7769198265662, -122.426707747337) | 7 | 9 | 11 | 28852 | 10 | |
30324 | 132146 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004850.84177 | 2111084.51569 | 37.7769100106119 | -122.426741215961 | (37.7769100106119, -122.426741215961) | 7 | 9 | 11 | 28852 | 10 | |||
132277 | 132147 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004824.24441 | 2111082.07039 | 37.7769017926211 | -122.4268330502 | (37.7769017926211, -122.4268330502) | 7 | 9 | 11 | 28852 | 10 | |||
153357 | 132148 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6004787.54086 | 2111075.34441 | 37.7768812494174 | -122.426959539871 | (37.7768812494174, -122.426959539871) | 7 | 9 | 11 | 28852 | 10 | |||
173257 | 132144 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 525 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004910.26431 | 2111067.91228 | 37.7768677811601 | -122.426534472605 | (37.7768677811601, -122.426534472605) | 7 | 9 | 11 | 28852 | 10 | |||
127960 | 132149 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004753.38188 | 2111070.56139 | 37.7768661848602 | -122.427077365453 | (37.7768661848602, -122.427077365453) | 7 | 9 | 11 | 28852 | 10 | |||
153119 | 132143 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 525 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004895.04277 | 2111066.14782 | 37.7768620758709 | -122.426587002881 | (37.7768620758709, -122.426587002881) | 7 | 9 | 11 | 28852 | 10 | |||
92940 | 132150 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6004720.2552 | 2111067.25332 | 37.7768552284141 | -122.427191725035 | (37.7768552284141, -122.427191725035) | 7 | 9 | 11 | 28852 | 10 | |||
64393 | 132142 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 525 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004877.96842 | 2111064.00554 | 37.7768552284082 | -122.426645915672 | (37.7768552284082, -122.426645915672) | 7 | 9 | 11 | 28852 | 10 | |||
147680 | 132151 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004697.15203 | 2111064.23767 | 37.7768456416404 | -122.427271431055 | (37.7768456416404, -122.427271431055) | 7 | 9 | 11 | 28852 | 10 | |||
118488 | 141413 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 530 IVY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004701.4857 | 2111062.9803 | 37.7768424342938 | -122.427256349988 | (37.7768424342938, -122.427256349988) | 7 | 9 | 11 | 28852 | 10 | |||
79361 | 132152 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004681.57966 | 2111062.06426 | 37.7768387933051 | -122.427325145748 | (37.7768387933051, -122.427325145748) | 7 | 9 | 11 | 28852 | 10 | |||
94633 | 132153 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004662.5128 | 2111060.462 | 37.776833315546 | -122.427390989626 | (37.776833315546, -122.427390989626) | 7 | 9 | 11 | 28852 | 10 | |||
169284 | 141415 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 530 IVY ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004662.5142 | 2111058.1591 | 37.7768269924265 | -122.427390820691 | (37.7768269924265, -122.427390820691) | 7 | 9 | 11 | 28852 | 10 | |||
131223 | 132154 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004644.42691 | 2111057.84188 | 37.7768250984387 | -122.427453367493 | (37.7768250984387, -122.427453367493) | 7 | 9 | 11 | 28852 | 10 | |||
140541 | 132155 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004627.84301 | 2111055.1905 | 37.7768168804195 | -122.427510547282 | (37.7768168804195, -122.427510547282) | 7 | 9 | 11 | 28852 | 10 | |||
54796 | 141417 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 530 IVY ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004625.1496 | 2111052.9361 | 37.776810538049 | -122.427519703953 | (37.776810538049, -122.427519703953) | 7 | 9 | 11 | 28852 | 10 | |||
16787 | 105348 | Undocumented 4 | Photinia fraseri :: Photinia: Chinese photinia 166 | 651X Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6004248.77005 | 2110989.99433 | 37.7766164199227 | -122.428817225763 | (37.7766164199227, -122.428817225763) | 7 | 9 | 11 | 28852 | 10 | |||
42356 | 105346 | Undocumented 4 | Photinia fraseri :: Photinia: Chinese photinia 166 | 651X Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004248.77005 | 2110989.99433 | 37.7766164199227 | -122.428817225763 | (37.7766164199227, -122.428817225763) | 7 | 9 | 11 | 28852 | 10 | |||
74929 | 138930 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 666 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004176.0708 | 2110989.9993 | 37.7766123186068 | -122.429068714009 | (37.7766123186068, -122.429068714009) | 7 | 9 | 11 | 28852 | 10 | |||
41587 | 138963 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 645 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004237.2429 | 2110976.1269 | 37.7765776909409 | -122.428856112669 | (37.7765776909409, -122.428856112669) | 7 | 9 | 11 | 28852 | 10 | |||
104964 | 138961 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 659 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004210.501 | 2110971.7814 | 37.7765642456394 | -122.428948310762 | (37.7765642456394, -122.428948310762) | 7 | 9 | 11 | 28852 | 10 | |||
91663 | 140232 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2217 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997153.7791 | 2110495.4596 | 37.7748544334109 | -122.453325023475 | (37.7748544334109, -122.453325023475) | 15 | 5 | 2 | 29492 | 16 | |||
84578 | 140233 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 SHRADER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997236.5638 | 2110458.2831 | 37.7747571011004 | -122.453035971219 | (37.7747571011004, -122.453035971219) | 15 | 5 | 2 | 29492 | 16 | |||
11822 | 142331 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 406 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000213.6336 | 2110347.5597 | 37.7746232471577 | -122.442729755961 | (37.7746232471577, -122.442729755961) | 15 | 5 | 11 | 29492 | 16 | |||
132030 | 247382 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 363 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002200.4098 | 2109794.4105 | 37.7732174971181 | -122.43581752718 | (37.7732174971181, -122.43581752718) | 15 | 5 | 11 | 29492 | 9 | |||
126637 | 247498 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 348 Scott St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6002258.2648 | 2109741.2734 | 37.7730748820821 | -122.43561359709 | (37.7730748820821, -122.43561359709) | 15 | 5 | 11 | 29492 | 9 | |||
109846 | 246514 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 73 Waller St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005362.30932 | 2109213.80064 | 37.7718023848053 | -122.424838771211 | (37.7718023848053, -122.424838771211) | 7 | 9 | 5 | 28852 | 10 | |||
136418 | 56794 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1303 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/1974 12:00:00 AM | 3x3 | Permit Number 14019 | 6000327.28850998 | 2109204.10022929 | 37.7714900745599 | -122.4422544996 | (37.7714900745599, -122.4422544996) | 15 | 5 | 11 | 29492 | 9 | ||
95413 | 106022 | Undocumented 4 | Photinia fraseri :: Photinia: Chinese photinia 166 | 181 Buena Vista Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | |||||
148590 | 234466 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 709 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002112.19122 | 2108241.56843 | 37.7689487658049 | -122.436011549895 | (37.7689487658049, -122.436011549895) | 15 | 5 | 5 | 29492 | 3 | |||
162920 | 234465 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 90 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001962.28164 | 2108178.26403 | 37.7687664300461 | -122.436525544813 | (37.7687664300461, -122.436525544813) | 15 | 5 | 5 | 29492 | 3 | |||
134913 | 234464 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 90 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001962.84457 | 2108154.72248 | 37.7687018227487 | -122.436521912476 | (37.7687018227487, -122.436521912476) | 15 | 5 | 5 | 29492 | 3 | |||
170926 | 234457 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 6 Park Hill Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6001153.42663 | 2107602.71165 | 37.7671401095592 | -122.439282048744 | (37.7671401095592, -122.439282048744) | 15 | 5 | 5 | 29492 | 3 | |||
113105 | 234438 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 786 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998023.26528 | 2107589.70092 | 37.7669257633449 | -122.450107819521 | (37.7669257633449, -122.450107819521) | 15 | 5 | 11 | 29492 | 9 | |||
122271 | 234429 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 63 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005807.69002 | 2106902.62008 | 37.7654815807348 | -122.423133859862 | (37.7654815807348, -122.423133859862) | 8 | 4 | 5 | 28853 | 19 | |||
9501 | 66781 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 63 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2017 12:00:00 AM | 3 | Permit Number 30050 | 6005821.27951384 | 2106893.65445384 | 37.7654577301272 | -122.423086219508 | (37.7654577301272, -122.423086219508) | 8 | 4 | 5 | 28853 | 19 | |
63522 | 234425 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 350 Church St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004155.01217 | 2106845.26287 | 37.7652306887714 | -122.428846008149 | (37.7652306887714, -122.428846008149) | 8 | 4 | 5 | 28862 | 3 | |||
27093 | 234423 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 360 Church St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6004155.50477 | 2106788.46961 | 37.765074776016 | -122.428840255169 | (37.765074776016, -122.428840255169) | 8 | 4 | 5 | 28862 | 3 | |||
76620 | 234422 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 370 Church St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6004156.87328 | 2106762.65224 | 37.7650039651812 | -122.428833681136 | (37.7650039651812, -122.428833681136) | 8 | 4 | 5 | 28862 | 3 |
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) );