trees
8,758 rows where qSpecies_id = 16 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78026 | 102055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1500 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5990817.04463 | 2111335.32945 | 37.776795239874 | -122.475306219453 | (37.776795239874, -122.475306219453) | 11 | 6 | 2 | 54 | 26 | |||
125839 | 102115 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | Permit Number 52469 | 6015181.7 | 2089440.8 | 37.7180595657824 | -122.389491420596 | (37.7180595657824, -122.389491420596) | 10 | 3 | 8 | 58 | 1 | |
80511 | 102152 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003792.2 | 2100904.7 | 37.7488987706557 | -122.429677160081 | (37.7488987706557, -122.429677160081) | 2 | 4 | 5 | 28862 | 22 | |||
193654 | 102153 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Clipper St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003792.2 | 2100904.7 | 37.7488987706557 | -122.429677160081 | (37.7488987706557, -122.429677160081) | 2 | 4 | 5 | 28862 | 22 | |||
1109 | 102184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1840X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | ||
149760 | 102363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 570 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 781804 | 5986921.1519 | 2112022.58894 | 37.7784556726268 | -122.488833631324 | (37.7784556726268, -122.488833631324) | 11 | 6 | 2 | 55 | 26 | ||
147649 | 102367 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 370 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 769632 | 6010509.7 | 2091399.6 | 37.7231778784556 | -122.405778481748 | (37.7231778784556, -122.405778481748) | 10 | 3 | 7 | 309 | 28 | |||
152224 | 1024 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1936 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000869.85642 | 2090880.51088 | 37.721208772055 | -122.439064279706 | (37.721208772055, -122.439064279706) | 9 | 7 | 6 | 28861 | 25 | |||
64752 | 102570 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 107 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | Permit Number 769786 | 5990356.6 | 2090236.8 | 37.7188374921756 | -122.475358242341 | (37.7188374921756, -122.475358242341) | 1 | 8 | 4 | 64 | 14 | |||
138638 | 102661 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3399X Wawona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
33668 | 102791 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983413 | 2105597.3 | 37.7606083127672 | -122.500494252669 | (37.7606083127672, -122.500494252669) | 1 | 8 | 3 | 56 | 35 | ||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10168 | 102888 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2940 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2106758 | 37.7651615533416 | -122.418394378814 | (37.7651615533416, -122.418394378814) | 8 | 4 | 7 | 28853 | 19 | ||||
9864 | 102975 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
184721 | 102976 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
121430 | 102977 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
48038 | 102978 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
131685 | 102979 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
92267 | 102980 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
176539 | 102981 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
172116 | 102982 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
5054 | 102983 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
65558 | 102984 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
79428 | 102985 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
32718 | 102991 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5993582.30378 | 2110700.03815 | 37.7752107945366 | -122.465694270173 | (37.7752107945366, -122.465694270173) | 11 | 6 | 2 | 54 | 11 | |||
4790 | 102992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 5 | 3x3 | 5993571.87038 | 2110700.08123 | 37.7752103110101 | -122.465730364497 | (37.7752103110101, -122.465730364497) | 11 | 6 | 2 | 54 | 11 | ||
67888 | 102993 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993560.89928 | 2110699.78339 | 37.7752088603815 | -122.465768294056 | (37.7752088603815, -122.465768294056) | 11 | 6 | 2 | 54 | 11 | |||
92407 | 102994 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5993540.84977 | 2110696.68247 | 37.7751991895497 | -122.465837423916 | (37.7751991895497, -122.465837423916) | 11 | 6 | 2 | 54 | 11 | |||
52306 | 103014 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1950X Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6000619.3 | 2112146.9 | 37.7795868963645 | -122.441455622144 | (37.7795868963645, -122.441455622144) | 15 | 5 | 1 | 29490 | 16 | |||
152780 | 103015 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1950X Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6000619.3 | 2112146.9 | 37.7795868963645 | -122.441455622144 | (37.7795868963645, -122.441455622144) | 15 | 5 | 1 | 29490 | 16 | |||
192196 | 103016 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1950X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6000619.3 | 2112146.9 | 37.7795868963645 | -122.441455622144 | (37.7795868963645, -122.441455622144) | 15 | 5 | 1 | 29490 | 16 | |||
188313 | 103056 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 48234 | 5986769.6009 | 2103052.0978 | 37.7538163512241 | -122.488698364121 | (37.7538163512241, -122.488698364121) | 1 | 8 | 3 | 56 | 35 | |||
81074 | 103057 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 48234 | 5986734.5182 | 2103049.3281 | 37.7538066990338 | -122.488819482963 | (37.7538066990338, -122.488819482963) | 1 | 8 | 3 | 56 | 35 | |||
173559 | 103058 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 48234 | 5986707.2829 | 2103049.7897 | 37.7538063769852 | -122.48891370155 | (37.7538063769852, -122.48891370155) | 1 | 8 | 3 | 56 | 35 | |||
123673 | 103059 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Permit Number 48234 | 5986679.5861 | 2103049.7897 | 37.7538047604978 | -122.489009482156 | (37.7538047604978, -122.489009482156) | 1 | 8 | 3 | 56 | 35 | |||
193120 | 103060 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2447 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5986361.646 | 2102961.746 | 37.7535444547699 | -122.490102501334 | (37.7535444547699, -122.490102501334) | 1 | 8 | 3 | 56 | 35 | |||
46601 | 103061 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2545 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5986068.1215 | 2102949.8889 | 37.7534947530434 | -122.491116686207 | (37.7534947530434, -122.491116686207) | 1 | 8 | 3 | 56 | 35 | |||
25203 | 1031 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1984 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000748.31196 | 2090644.16977 | 37.7205529162678 | -122.439467489832 | (37.7205529162678, -122.439467489832) | 9 | 7 | 6 | 28861 | 25 | |||
9332 | 103261 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4174 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 7x15 | 6002762 | 2100662 | 37.7481739852998 | -122.433222250243 | (37.7481739852998, -122.433222250243) | 2 | 4 | 5 | 28862 | 22 | |||
120480 | 1033 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1986 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000734.4092 | 2090618.0584 | 37.7204804291149 | -122.439513676309 | (37.7204804291149, -122.439513676309) | 9 | 7 | 6 | 28861 | 25 | |||
124683 | 1034 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1988 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6000717.70682 | 2090589.89348 | 37.7204021440199 | -122.439569392914 | (37.7204021440199, -122.439569392914) | 9 | 7 | 6 | 28861 | 25 | |||
158485 | 103521 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 408 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5989073.59869 | 2112519.47278 | 37.7799453577662 | -122.481423991786 | (37.7799453577662, -122.481423991786) | 11 | 6 | 2 | 55 | 26 | |||
80772 | 103533 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 765 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5981342.78377 | 2110521.68267 | 37.7740074952585 | -122.508019545549 | (37.7740074952585, -122.508019545549) | 11 | 6 | 2 | 55 | 26 | ||||
42847 | 103534 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 765 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5981342.75044 | 2110506.14009 | 37.7739648179328 | -122.508018507082 | (37.7739648179328, -122.508018507082) | 11 | 6 | 2 | 55 | 26 | ||||
176673 | 103699 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5981012.38843 | 2110301.40953 | 37.7733832167065 | -122.509146058065 | (37.7733832167065, -122.509146058065) | 11 | 6 | 2 | 55 | 26 | |||
25329 | 1037 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1995 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000781.27408 | 2090531.40269 | 37.7202451592572 | -122.439345471618 | (37.7202451592572, -122.439345471618) | 9 | 7 | 6 | 28861 | 25 | |||
174398 | 103701 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4700 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 5980981.42101 | 2110300.97358 | 37.7733801939619 | -122.50925314442 | (37.7733801939619, -122.50925314442) | 11 | 6 | 2 | 55 | 26 | |||
185693 | 103704 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4700 Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x4 | 5980950.21824 | 2110299.88198 | 37.7733753570212 | -122.509360996158 | (37.7733753570212, -122.509360996158) | 11 | 6 | 2 | 55 | 26 | |||
174002 | 1038 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1998 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6000639.40978 | 2090456.17942 | 37.720030538913 | -122.439830457778 | (37.720030538913, -122.439830457778) | 9 | 7 | 6 | 28861 | 25 | |||
161704 | 1039 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1999X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 40 | 4X4 | 6000719.67817 | 2090412.71158 | 37.7199157548074 | -122.439549883589 | (37.7199157548074, -122.439549883589) | 9 | 7 | 6 | 28861 | 25 | ||
46598 | 103945 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 137 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2013 12:00:00 AM | 20 | 3x3 | Permit Number 770063 | 6005598 | 2099028 | 37.7438478677712 | -122.423299304186 | (37.7438478677712, -122.423299304186) | 2 | 7 | 5 | 28859 | 22 | |
76498 | 103992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 490 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x9 | 5992221.43752 | 2112120.37054 | 37.7790320515793 | -122.470505237216 | (37.7790320515793, -122.470505237216) | 11 | 6 | 2 | 54 | 11 | |||
94504 | 104041 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 707 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5991044 | 2099058 | 37.7430981073952 | -122.473625322134 | (37.7430981073952, -122.473625322134) | 1 | 8 | 4 | 29491 | 40 | |||
128722 | 104042 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x13 | 5987099 | 2115331 | 37.7875500018464 | -122.488461609309 | (37.7875500018464, -122.488461609309) | 11 | 6 | 1 | 55 | 33 | ||||
24136 | 104073 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7325 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769874 | 5984254.45789 | 2112409.73479 | 37.7793626746855 | -122.498087186944 | (37.7793626746855, -122.498087186944) | 11 | 6 | 2 | 55 | 26 | |
114752 | 1041 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1999X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6000719.67817 | 2090412.71158 | 37.7199157548074 | -122.439549883589 | (37.7199157548074, -122.439549883589) | 9 | 7 | 6 | 28861 | 25 | |||
47604 | 104262 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
66899 | 104263 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
178487 | 104264 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
108485 | 104265 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
94320 | 104266 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
137587 | 104319 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 74 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002422 | 2106797 | 37.7649999301596 | -122.434836624189 | (37.7649999301596, -122.434836624189) | 15 | 5 | 5 | 28862 | 3 | ||||
121824 | 104324 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
37928 | 104325 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X Beaver St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
179744 | 104326 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X Beaver St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002383 | 2106795 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | 15 | 5 | 5 | 28862 | 3 | ||||
176267 | 1044 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2006 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000601.62098 | 2090401.54806 | 37.7198783824605 | -122.439957165309 | (37.7198783824605, -122.439957165309) | 9 | 7 | 6 | 28861 | 25 | |||
14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
80975 | 104550 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 428x PANORAMA DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5997536 | 2102327 | 37.7524478160364 | -122.451413569464 | (37.7524478160364, -122.451413569464) | 1 | 5 | 4 | 63 | 38 | |||
28982 | 104551 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 428 PANORAMA DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5997536 | 2102327 | 37.7524478160364 | -122.451413569464 | (37.7524478160364, -122.451413569464) | 1 | 5 | 4 | 63 | 38 | ||||
193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
147401 | 104553 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
69486 | 104554 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
164386 | 104555 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
120448 | 104556 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
26451 | 104562 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 210 FLOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999356 | 2094123 | 37.7300256415139 | -122.444530151255 | (37.7300256415139, -122.444530151255) | 9 | 7 | 4 | 28861 | 40 | |||
60770 | 104563 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 210 FLOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999356 | 2094123 | 37.7300256415139 | -122.444530151255 | (37.7300256415139, -122.444530151255) | 9 | 7 | 4 | 28861 | 40 | |||
29132 | 104609 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
156522 | 104610 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
132705 | 104611 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
191125 | 104612 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
172172 | 104613 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
109779 | 104614 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
187430 | 104646 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1455X Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001386.81709 | 2099547.0285 | 37.7450344302078 | -122.437897729467 | (37.7450344302078, -122.437897729467) | 2 | 7 | 5 | 63 | 22 | |||||
20631 | 104678 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3531-3535 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003359 | 2106442.3 | 37.7640791638998 | -122.431570451949 | (37.7640791638998, -122.431570451949) | 15 | 4 | 5 | 28862 | 3 | ||||
23118 | 104735 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
29286 | 104780 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 177 GLADSTONE DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005563.4 | 2093681.6 | 37.7291658964922 | -122.423039015945 | (37.7291658964922, -122.423039015945) | 9 | 7 | 6 | 28861 | 5 | |||
119781 | 104800 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 111-115 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768776 | 6005465.9 | 2103968.9 | 37.7574069834837 | -122.424107381989 | (37.7574069834837, -122.424107381989) | 2 | 4 | 5 | 28859 | 19 | |||
186163 | 104801 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 111-115 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005465.9 | 2103968.9 | 37.7574069834837 | -122.424107381989 | (37.7574069834837, -122.424107381989) | 2 | 4 | 5 | 28859 | 19 | ||||
58194 | 104989 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1631 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989627.0542 | 2104247.5544 | 37.7572650916111 | -122.478904174491 | (37.7572650916111, -122.478904174491) | 1 | 8 | 3 | 56 | 35 | |||
168700 | 105024 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3945 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5983296.16268 | 2111005.55007 | 37.7754509595451 | -122.501298383825 | (37.7754509595451, -122.501298383825) | 11 | 6 | 2 | 55 | 26 | |||
82679 | 105055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6333 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987343.5 | 2112490.3 | 37.7797645138094 | -122.487406953976 | (37.7797645138094, -122.487406953976) | 11 | 6 | 2 | 55 | 26 | ||
107020 | 105056 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6333 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987343.5 | 2112490.3 | 37.7797645138094 | -122.487406953976 | (37.7797645138094, -122.487406953976) | 11 | 6 | 2 | 55 | 26 | ||
120017 | 105072 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 88X PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6007074 | 2099135 | 37.7442248567037 | -122.418203213837 | (37.7442248567037, -122.418203213837) | 2 | 7 | 7 | 28859 | 2 | |||
139005 | 10514 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5997476.97726 | 2108439.50555 | 37.7692278336416 | -122.452058652072 | (37.7692278336416, -122.452058652072) | 15 | 5 | 11 | 29492 | 9 | |||
123538 | 10515 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/2017 12:00:00 AM | 3 | 3X3 | 5997497.7686 | 2108463.8393 | 37.7692958388006 | -122.451988492124 | (37.7692958388006, -122.451988492124) | 15 | 5 | 11 | 29492 | 9 | ||
48629 | 105164 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 15 | 5x5 | 6014842.39521 | 2095664.68421 | 37.735130289038 | -122.391099047201 | (37.735130289038, -122.391099047201) | 10 | 3 | 8 | 58 | 1 | |||
135817 | 105173 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1601X NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | Arts Commission | 13 | 4x4 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | |
121641 | 105209 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2457 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x3 | 5984543.8996 | 2098504.0949 | 37.7411986451775 | -122.496059728981 | (37.7411986451775, -122.496059728981) | 1 | 8 | 3 | 29491 | 35 | |||
167219 | 10524 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 549X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010282.8931976 | 2090221.6536154 | 37.7199307950248 | -122.406479548712 | (37.7199307950248, -122.406479548712) | 10 | 7 | 8 | 309 | 28 | |||
163632 | 10525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 630X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010033.9923398 | 2090286.8003786 | 37.7200957469146 | -122.40734450707 | (37.7200957469146, -122.40734450707) | 10 | 3 | 7 | 309 | 28 |
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) );