trees
858 rows where qSpecies_id = 85 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71261 | 249429 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6007371.4377 | 2113305.12395 | 37.7831494521267 | -122.418179157466 | (37.7831494521267, -122.418179157466) | 7 | 9 | 9 | 28852 | 36 | |||
| 72524 | 99310 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007548.2 | 2113343.2 | 37.7832639475046 | -122.417570329335 | (37.7832639475046, -122.417570329335) | 7 | 9 | 9 | 28852 | 36 | ||||
| 103211 | 136552 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 535 Post St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009695.68796 | 2115014.2038 | 37.7879727267153 | -122.410258865966 | (37.7879727267153, -122.410258865966) | 5 | 1 | 10 | 28852 | 36 | |||
| 106943 | 249428 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6007312.28325 | 2113298.00589 | 37.7831265778782 | -122.418383303558 | (37.7831265778782, -122.418383303558) | 7 | 9 | 9 | 28852 | 36 | |||
| 110322 | 249430 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 3 | : | Tree | Private 2 | 13 | Width 4ft | 6007422.07723 | 2113312.26765 | 37.7831719171937 | -122.418004471327 | (37.7831719171937, -122.418004471327) | 7 | 9 | 9 | 28852 | 36 | |||
| 148657 | 136551 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 535 Post St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009633.52573 | 2115005.6617 | 37.7879457875105 | -122.410473333578 | (37.7879457875105, -122.410473333578) | 5 | 1 | 10 | 28852 | 36 | |||
| 166728 | 99311 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007548.2 | 2113343.2 | 37.7832639475046 | -122.417570329335 | (37.7832639475046, -122.417570329335) | 7 | 9 | 9 | 28852 | 36 | ||||
| 185147 | 63948 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2007 12:00:00 AM | Permit No. 49233 | 6007549.75522386 | 2113332.29045601 | 37.7832340800522 | -122.417564175407 | (37.7832340800522, -122.417564175407) | 7 | 9 | 9 | 28852 | 36 | ||
| 186907 | 136550 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 535 Post St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009600.17955 | 2115001.02836 | 37.7879311960125 | -122.410588378478 | (37.7879311960125, -122.410588378478) | 5 | 1 | 10 | 28852 | 36 | |||
| 849 | 51822 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008911.92726 | 2109811.9687 | 37.7736446648878 | -122.412602652111 | (37.7736446648878, -122.412602652111) | 8 | 2 | 9 | 28853 | 34 | ||
| 8080 | 75081 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 172 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 8x9 | 6010488.28034 | 2111342.37314 | 37.7779351433246 | -122.407257684389 | (37.7779351433246, -122.407257684389) | 14 | 2 | 9 | 28853 | 34 | |||
| 19679 | 40601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.27714 | 37.7685911090192 | -122.402763284706 | (37.7685911090192, -122.402763284706) | 8 | 2 | 8 | 28853 | 20 | |
| 20091 | 240883 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 499 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005534.08174 | 2107810.45937 | 37.7679588469372 | -122.424144778774 | (37.7679588469372, -122.424144778774) | 8 | 4 | 5 | 28853 | 19 | |||
| 22257 | 197762 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 967 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6008013.25237 | 2109878.84045 | 37.7737778014386 | -122.41571605105 | (37.7737778014386, -122.41571605105) | 8 | 2 | 9 | 28853 | 34 | |||
| 27267 | 73457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.27808 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | 8 | 2 | 9 | 28853 | 34 | ||
| 27271 | 50760 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
| 32683 | 245229 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 267 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005011.87346 | 2108197.61767 | 37.7689923919147 | -122.425978603426 | (37.7689923919147, -122.425978603426) | 8 | 4 | 5 | 28853 | 19 | |||
| 34629 | 197801 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011521.16357 | 2109490.57736 | 37.7729082910133 | -122.403554237551 | (37.7729082910133, -122.403554237551) | 14 | 2 | 9 | 28853 | 34 | |||
| 37599 | 51826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008951.49863 | 2109770.91917 | 37.7735341733012 | -122.412462865995 | (37.7735341733012, -122.412462865995) | 8 | 2 | 9 | 28853 | 34 | ||
| 41360 | 197804 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011235.3992 | 2109217.88632 | 37.7721435776893 | -122.404523536758 | (37.7721435776893, -122.404523536758) | 14 | 2 | 9 | 28853 | 34 | |||
| 42424 | 197761 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6010003.68567 | 2109694.36237 | 37.773382957679 | -122.408817777045 | (37.773382957679, -122.408817777045) | 14 | 2 | 9 | 28853 | 34 | |||
| 43126 | 240859 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005815.33313 | 2106780.63921 | 37.7651470814965 | -122.423098753019 | (37.7651470814965, -122.423098753019) | 8 | 4 | 5 | 28853 | 19 | |||
| 48698 | 108284 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
| 49411 | 51824 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008839.3407 | 2109885.31137 | 37.7738419725734 | -122.412858927409 | (37.7738419725734, -122.412858927409) | 8 | 2 | 9 | 28853 | 34 | ||
| 49931 | 50761 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
| 49993 | 197756 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6009912.73431 | 2109600.17323 | 37.7731192414011 | -122.409125744471 | (37.7731192414011, -122.409125744471) | 14 | 2 | 9 | 28853 | 34 | |||
| 52108 | 197809 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008647.67456 | 2110087.31944 | 37.77438587894 | -122.413536223923 | (37.77438587894, -122.413536223923) | 8 | 2 | 9 | 28853 | 34 | |||
| 54197 | 51828 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008816.98399 | 2109909.48162 | 37.7739070834758 | -122.412937972431 | (37.7739070834758, -122.412937972431) | 8 | 2 | 9 | 28853 | 34 | ||
| 56442 | 197808 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008660.65845 | 2110075.31719 | 37.7743536526336 | -122.413490461037 | (37.7743536526336, -122.413490461037) | 8 | 2 | 9 | 28853 | 34 | |||
| 59274 | 85361 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | 12 | Permit Number 49638 | 6008746.14707 | 2109938.9547 | 37.7739840330773 | -122.413185094432 | (37.7739840330773, -122.413185094432) | 8 | 2 | 9 | 28853 | 34 | ||
| 68638 | 57152 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 53479 | 6007084.13005826 | 2107360.24310609 | 37.7668100557647 | -122.41875139025 | (37.7668100557647, -122.41875139025) | 8 | 4 | 7 | 28853 | 19 | |||
| 74181 | 40602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865592 | (37.7686118231125, -122.40238865592) | 8 | 2 | 8 | 28853 | 20 | |
| 76285 | 240860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005814.59305 | 2106796.61369 | 37.7651909018693 | -122.423102448325 | (37.7651909018693, -122.423102448325) | 8 | 4 | 5 | 28853 | 19 | |||
| 79636 | 51823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008893.04946 | 2109829.84045 | 37.7736926770172 | -122.412669217211 | (37.7736926770172, -122.412669217211) | 8 | 2 | 9 | 28853 | 34 | ||
| 79981 | 197760 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009984.84437 | 2109679.97053 | 37.773342385672 | -122.408881936452 | (37.773342385672, -122.408881936452) | 14 | 2 | 9 | 28853 | 34 | ||||
| 94951 | 40575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011865.56753 | 2107924.68372 | 37.7686279344547 | -122.402252780039 | (37.7686279344547, -122.402252780039) | 8 | 2 | 8 | 28853 | 20 | |
| 98061 | 100791 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961 | 2109679 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | 14 | 2 | 9 | 28853 | 34 | |
| 108295 | 197811 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008628.59591 | 2110107.11154 | 37.7744391520861 | -122.413603620921 | (37.7744391520861, -122.413603620921) | 8 | 2 | 9 | 28853 | 34 | |||
| 110157 | 197806 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011212.56245 | 2109198.11372 | 37.7720880103782 | -122.404601139252 | (37.7720880103782, -122.404601139252) | 14 | 2 | 9 | 28853 | 34 | |||
| 110441 | 51820 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008882.21436 | 2109841.08005 | 37.7737229301921 | -122.412707492378 | (37.7737229301921, -122.412707492378) | 8 | 2 | 9 | 28853 | 34 | ||
| 112644 | 51825 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 9 | Permit Number 48062 | 6008869.29878 | 2109856.43438 | 37.7737643646643 | -122.412753255267 | (37.7737643646643, -122.412753255267) | 8 | 2 | 9 | 28853 | 34 | ||
| 113598 | 51831 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008936.17347 | 2109786.08328 | 37.7735749503435 | -122.41251695031 | (37.7735749503435, -122.41251695031) | 8 | 2 | 9 | 28853 | 34 | ||
| 114269 | 245227 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 98 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008059.54511 | 2107998.03591 | 37.7686161569496 | -122.415422738079 | (37.7686161569496, -122.415422738079) | 8 | 4 | 7 | 28853 | 19 | |||
| 117787 | 51830 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008991.04076 | 2109728.43276 | 37.7734197345703 | -122.41232307986 | (37.7734197345703, -122.41232307986) | 8 | 2 | 9 | 28853 | 34 | ||
| 122872 | 197759 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009794.14273 | 2110264.73929 | 37.7749373405286 | -122.409582883362 | (37.7749373405286, -122.409582883362) | 8 | 2 | 9 | 28853 | 34 | ||||
| 124586 | 197802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011487.83724 | 2109458.15845 | 37.7728174145236 | -122.403667236476 | (37.7728174145236, -122.403667236476) | 14 | 2 | 9 | 28853 | 34 | |||
| 124818 | 240857 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005817.41296 | 2106751.86939 | 37.7650682037548 | -122.423089514295 | (37.7650682037548, -122.423089514295) | 8 | 4 | 5 | 28853 | 19 | |||
| 128350 | 70674 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009713.37345 | 2110904.22061 | 37.7766886802763 | -122.409907434288 | (37.7766886802763, -122.409907434288) | 8 | 2 | 9 | 28853 | 34 | ||
| 129206 | 40576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011845.30553 | 2107921.74272 | 37.7686187280976 | -122.402322658262 | (37.7686187280976, -122.402322658262) | 8 | 2 | 8 | 28853 | 20 | |
| 129768 | 56463 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 495 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005502.51915575 | 2107805.81880506 | 37.7679443229226 | -122.424253620258 | (37.7679443229226, -122.424253620258) | 8 | 4 | 5 | 28853 | 19 | |||||
| 130774 | 197755 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6009884.52157 | 2109578.01203 | 37.7730568113471 | -122.409221772263 | (37.7730568113471, -122.409221772263) | 14 | 2 | 9 | 28853 | 34 | |||
| 131971 | 40579 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 14 | Permit Number 47084 | 6011781.78779 | 2107916.60765 | 37.7686010824916 | -122.402542001114 | (37.7686010824916, -122.402542001114) | 8 | 2 | 8 | 28853 | 20 | |
| 133443 | 197810 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008638.52776 | 2110098.76438 | 37.7744167904456 | -122.413568674158 | (37.7744167904456, -122.413568674158) | 8 | 2 | 9 | 28853 | 34 | |||
| 133819 | 197757 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6009931.91498 | 2109631.18124 | 37.7732054566946 | -122.409061584123 | (37.7732054566946, -122.409061584123) | 14 | 2 | 9 | 28853 | 34 | |||
| 134210 | 197772 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 370 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011991.34418 | 2106649.17126 | 37.7651326842421 | -122.401728059814 | (37.7651326842421, -122.401728059814) | 8 | 3 | 8 | 28853 | 20 | |||
| 134928 | 245278 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008034.93749 | 2108017.16793 | 37.7686673058729 | -122.415509208786 | (37.7686673058729, -122.415509208786) | 8 | 4 | 7 | 28853 | 19 | |||
| 138467 | 40600 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 16 | Permit Number 47084 | 6011742.75079 | 2107914.88662 | 37.768594177497 | -122.402676906637 | (37.768594177497, -122.402676906637) | 8 | 2 | 8 | 28853 | 20 | |
| 139752 | 40581 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 18 | Permit Number 47084 | 6011805.12388 | 2107918.92734 | 37.7686087546157 | -122.402461446151 | (37.7686087546157, -122.402461446151) | 8 | 2 | 8 | 28853 | 20 | |
| 141254 | 92895 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009778 | 2109505 | 37.7728503689602 | -122.409585091202 | (37.7728503689602, -122.409585091202) | 14 | 2 | 9 | 28853 | 34 | |||||
| 142126 | 245228 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 267 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004993.18691 | 2108197.15694 | 37.7689900707609 | -122.426043206255 | (37.7689900707609, -122.426043206255) | 8 | 4 | 5 | 28853 | 19 | |||
| 144871 | 240858 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005816.06228 | 2106764.13272 | 37.7651017997331 | -122.423095057704 | (37.7651017997331, -122.423095057704) | 8 | 4 | 5 | 28853 | 19 | |||
| 149495 | 197758 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6009958.32307 | 2109652.80645 | 37.7732663138222 | -122.408971760735 | (37.7732663138222, -122.408971760735) | 14 | 2 | 9 | 28853 | 34 | |||
| 153181 | 40599 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011762.41247 | 2107915.88375 | 37.7685980131212 | -122.402608968236 | (37.7685980131212, -122.402608968236) | 8 | 2 | 8 | 28853 | 20 | |
| 156412 | 197803 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011246.96295 | 2109228.4267 | 37.7721731654036 | -122.404484278649 | (37.7721731654036, -122.404484278649) | 14 | 2 | 9 | 28853 | 34 | |||
| 156697 | 197807 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 59 Grace St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008374.50878 | 2110266.71352 | 37.7748631104905 | -122.414493855329 | (37.7748631104905, -122.414493855329) | 8 | 2 | 9 | 28853 | 34 | |||
| 159492 | 100792 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961 | 2109679 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | 14 | 2 | 9 | 28853 | 34 | |
| 162092 | 240884 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 98 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008092.35816 | 2108001.44003 | 37.7686273481005 | -122.41530948107 | (37.7686273481005, -122.41530948107) | 8 | 4 | 7 | 28853 | 19 | |||
| 163930 | 197805 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011223.85709 | 2109208.39656 | 37.772116875933 | -122.40456279395 | (37.772116875933, -122.40456279395) | 14 | 2 | 9 | 28853 | 34 | |||
| 164722 | 51833 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008964.93422 | 2109757.47031 | 37.7734979998699 | -122.412415439325 | (37.7734979998699, -122.412415439325) | 8 | 2 | 9 | 28853 | 34 | ||
| 165479 | 240856 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005817.66838 | 2106738.29847 | 37.7650309556372 | -122.423087666179 | (37.7650309556372, -122.423087666179) | 8 | 4 | 5 | 28853 | 19 | |||
| 169825 | 51821 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008924.41107 | 2109799.01878 | 37.77360980807 | -122.412558552943 | (37.77360980807, -122.412558552943) | 8 | 2 | 9 | 28853 | 34 | ||
| 178227 | 51832 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008981.39309 | 2109738.92978 | 37.7734480155424 | -122.412357194742 | (37.7734480155424, -122.412357194742) | 8 | 2 | 9 | 28853 | 34 | ||
| 185282 | 240882 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 499 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005513.65121 | 2107810.11701 | 37.7679567533317 | -122.424215421419 | (37.7679567533317, -122.424215421419) | 8 | 4 | 5 | 28853 | 19 | |||
| 191633 | 51829 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 10 | Permit Number 48062 | 6008854.22415 | 2109872.0726 | 37.7738064574284 | -122.412806506809 | (37.7738064574284, -122.412806506809) | 8 | 2 | 9 | 28853 | 34 | ||
| 194145 | 51827 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 14 | Permit Number 48062 | 6008827.58817 | 2109898.72556 | 37.7738781451019 | -122.412900530062 | (37.7738781451019, -122.412900530062) | 8 | 2 | 9 | 28853 | 34 | ||
| 2442 | 35339 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 740 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 9 | Permit Number 38804 | 6013014.621 | 2103534.39703 | 37.7566372493387 | -122.397970249845 | (37.7566372493387, -122.397970249845) | 10 | 3 | 8 | 28856 | 29 | |
| 11004 | 51713 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012693.61148 | 2110101.74925 | 37.7746518507372 | -122.399541492249 | (37.7746518507372, -122.399541492249) | 14 | 2 | 9 | 28856 | 20 | ||
| 15296 | 49997 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.2211 | 2105187.35151 | 37.7612480878485 | -122.393598329713 | (37.7612480878485, -122.393598329713) | 10 | 3 | 8 | 28856 | 29 |
| 16391 | 197750 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6012005.03317 | 2110833.59776 | 37.7766229335303 | -122.401974894942 | (37.7766229335303, -122.401974894942) | 14 | 2 | 9 | 28856 | 34 | |||
| 16751 | 78587 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012314.29117 | 2102093.10716 | 37.7526407529845 | -122.400291031321 | (37.7526407529845, -122.400291031321) | 10 | 3 | 8 | 28856 | 29 | |||
| 17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 10 | 3 | 8 | 28856 | 29 | |||
| 17510 | 70565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6014527.51657 | 2111489.70716 | 37.7785649223813 | -122.39329474466 | (37.7785649223813, -122.39329474466) | 6 | 2 | 9 | 28856 | 34 | |||
| 18467 | 51710 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012671.60652 | 2110080.29176 | 37.7745917067712 | -122.399616105424 | (37.7745917067712, -122.399616105424) | 14 | 2 | 9 | 28856 | 20 | ||
| 19243 | 197785 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2347 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6010748.45807 | 2105046.89477 | 37.7606637578537 | -122.405914042413 | (37.7606637578537, -122.405914042413) | 10 | 3 | 8 | 28856 | 29 | ||||
| 19979 | 41630 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.7742530301757 | -122.400029064208 | (37.7742530301757, -122.400029064208) | 14 | 2 | 9 | 28856 | 20 | ||
| 22473 | 37940 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 728 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | 12 | Permit Number 46514 | 6015675.91863 | 2103966.98263 | 37.7579728963479 | -122.388796638862 | (37.7579728963479, -122.388796638862) | 10 | 3 | 8 | 28856 | 29 | |
| 23586 | 51714 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 14 | Permit Number 47987 | 6012645.95948 | 2110058.2702 | 37.7745298109235 | -122.399703277606 | (37.7745298109235, -122.399703277606) | 14 | 2 | 9 | 28856 | 20 | ||
| 30055 | 197791 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.99071 | 2105404.50767 | 37.7617657223333 | -122.39850136517 | (37.7617657223333, -122.39850136517) | 10 | 3 | 8 | 28856 | 29 | |||
| 31445 | 197792 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 228 Connecticut St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6013148.35308 | 2105968.0458 | 37.7633269624894 | -122.397678442332 | (37.7633269624894, -122.397678442332) | 14 | 3 | 8 | 28856 | 29 | |||
| 33501 | 197788 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2056 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011954.13771 | 2104694.98029 | 37.7597648350875 | -122.401719379549 | (37.7597648350875, -122.401719379549) | 10 | 3 | 8 | 28856 | 29 | |||
| 33843 | 51717 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 12 | Permit Number 47987 | 6012600.34291 | 2110009.85826 | 37.7743943397653 | -122.399857674991 | (37.7743943397653, -122.399857674991) | 14 | 2 | 9 | 28856 | 20 | ||
| 34667 | 197775 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012572.98246 | 2106081.16458 | 37.7636055050056 | -122.399676416648 | (37.7636055050056, -122.399676416648) | 14 | 3 | 8 | 28856 | 29 | |||
| 36252 | 197767 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015569.44669 | 2103464.91746 | 37.756588430534 | -122.38912981161 | (37.756588430534, -122.38912981161) | 10 | 3 | 8 | 28856 | 29 | |||
| 39190 | 41631 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 13 | Permit Number 47987 | 6012575.96802 | 2109987.3858 | 37.7743312765925 | -122.399940414441 | (37.7743312765925, -122.399940414441) | 14 | 2 | 9 | 28856 | 20 | ||
| 39646 | 93672 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 80 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53291 | 6013405 | 2106710 | 37.7653784929972 | -122.396842798823 | (37.7653784929972, -122.396842798823) | 14 | 3 | 8 | 28856 | 20 | |||
| 41124 | 50008 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014311.55635 | 2105196.94353 | 37.7612743885122 | -122.393601300174 | (37.7612743885122, -122.393601300174) | 10 | 3 | 8 | 28856 | 29 |
| 44332 | 197798 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 444 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013857.66162 | 2111727.99067 | 37.7791819571277 | -122.395628745281 | (37.7791819571277, -122.395628745281) | 6 | 2 | 9 | 28856 | 34 | |||
| 46814 | 51711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
| 48581 | 121492 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6012288.86366 | 2105128.25072 | 37.760973173204 | -122.400592156703 | (37.760973173204, -122.400592156703) | 10 | 3 | 8 | 28856 | 29 | ||||
| 52207 | 197781 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011867.97077 | 2105631.0205 | 37.7623301845026 | -122.402083196704 | (37.7623301845026, -122.402083196704) | 8 | 3 | 8 | 28856 | 29 |
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) );