trees
8,758 rows where qSpecies_id = 16 sorted by qAddress descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180102 | 13326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011657.72731 | 2090650.48596 | 37.7211850991863 | -122.401757321938 | (37.7211850991863, -122.401757321938) | 10 | 7 | 8 | 309 | 28 | |||
| 24037 | 108406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.415540737233 | (37.7814172463574, -122.415540737233) | 7 | 10 | 9 | 28852 | 36 | |
| 47186 | 108408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.415516217226 | (37.7812898924571, -122.415516217226) | 7 | 10 | 9 | 28852 | 36 | |
| 84973 | 108407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | 7 | 10 | 9 | 28852 | 36 | |
| 114952 | 108409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.7812331371452 | -122.415505707716 | (37.7812331371452, -122.415505707716) | 7 | 10 | 9 | 28852 | 36 | |
| 137011 | 108405 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581 | (37.7814823069089, -122.41555124581) | 7 | 10 | 9 | 28852 | 36 | |
| 149589 | 108410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530315 | -122.415496951018 | (37.781198530315, -122.415496951018) | 7 | 10 | 9 | 28852 | 36 | |
| 56597 | 131593 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 999 Green St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008359.29361 | 2118943.47544 | 37.7986865391195 | -122.415160808731 | (37.7986865391195, -122.415160808731) | 5 | 1 | 10 | 308 | 21 | ||||
| 147563 | 131595 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 999 Green St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008365.45395 | 2118940.10023 | 37.7986776178289 | -122.41513925288 | (37.7986776178289, -122.41513925288) | 5 | 1 | 10 | 308 | 21 | ||||
| 159908 | 131592 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 999 Green St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6008355.8018 | 2118946.79635 | 37.7986954612792 | -122.415173126746 | (37.7986954612792, -122.415173126746) | 5 | 1 | 10 | 308 | 21 | ||||
| 190207 | 131594 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 999 Green St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008361.61132 | 2118940.76942 | 37.7986792393119 | -122.41515259704 | (37.7986792393119, -122.41515259704) | 5 | 1 | 10 | 308 | 21 | ||||
| 194246 | 38488 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 999 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2003 12:00:00 AM | 12 | Permit Number 47240 | 6008353.25415 | 2118952.75652 | 37.7987116832495 | -122.415182364581 | (37.7987116832495, -122.415182364581) | 5 | 1 | 10 | 308 | 21 | |
| 47056 | 122449 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008865 | 2090425 | 37.7204097170763 | -122.411395091465 | (37.7204097170763, -122.411395091465) | 9 | 3 | 7 | 309 | 28 | ||||
| 154909 | 122450 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008865 | 2090425 | 37.7204097170763 | -122.411395091465 | (37.7204097170763, -122.411395091465) | 9 | 3 | 7 | 309 | 28 | ||||
| 158983 | 122451 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998x Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008865 | 2090425 | 37.7204097170763 | -122.411395091465 | (37.7204097170763, -122.411395091465) | 9 | 3 | 7 | 309 | 28 | ||||
| 3282 | 232681 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009404.5391 | 2103406.76128 | 37.7560850691817 | -122.410446255909 | (37.7560850691817, -122.410446255909) | 2 | 4 | 7 | 28859 | 19 | |||
| 13020 | 25365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 996 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000644.8782 | 2088863.97387 | 37.7156590125416 | -122.439697466259 | (37.7156590125416, -122.439697466259) | 9 | 7 | 6 | 28861 | 5 | |||
| 127850 | 25366 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 996 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6000654.63163 | 2088858.47925 | 37.715644480695 | -122.439663360361 | (37.715644480695, -122.439663360361) | 9 | 7 | 6 | 28861 | 5 | |||
| 54845 | 138957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 993 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003097.8821 | 2110980.6829 | 37.776525646894 | -122.432797813953 | (37.776525646894, -122.432797813953) | 15 | 9 | 11 | 29492 | 10 | |||
| 69792 | 38453 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 142162 | 38456 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 142867 | 38454 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.7274638040704 | -122.379579913535 | (37.7274638040704, -122.379579913535) | 10 | 3 | 8 | 58 | 1 | ||
| 179702 | 138958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 991 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003123.3612 | 2110983.4524 | 37.7765346962839 | -122.432709872383 | (37.7765346962839, -122.432709872383) | 15 | 9 | 11 | 29492 | 10 | |||
| 99114 | 122757 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99 Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x5 | 6001111 | 2107407 | 37.766600319422 | -122.439414765245 | (37.766600319422, -122.439414765245) | 15 | 5 | 5 | 29492 | 3 | |||
| 104776 | 232147 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99 Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001132.33948 | 2107453.47077 | 37.7667291310574 | -122.439344287218 | (37.7667291310574, -122.439344287218) | 15 | 5 | 5 | 29492 | 3 | |||
| 45866 | 183403 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99 Escolta Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | Permit Number 18001 | 5986843.3946 | 2097135.0609 | 37.7375740582752 | -122.488008432108 | (37.7375740582752, -122.488008432108) | 1 | 8 | 3 | 29491 | 35 | ||
| 124848 | 66160 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | Permit Number 29231 | 6013641.58815417 | 2094885.58391758 | 37.7329243309061 | -122.395196144067 | (37.7329243309061, -122.395196144067) | 10 | 3 | 8 | 58 | 1 | ||
| 165710 | 232645 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007978.74404 | 2098199.137 | 37.7417060688936 | -122.415008567908 | (37.7417060688936, -122.415008567908) | 2 | 7 | 7 | 28859 | 2 | |||
| 158117 | 107675 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98x LUNDYS LN | 1 | Unaccepted Street : Yard | Tree | Private 2 | 14 | 8x10 | 6006855 | 2099015 | 37.7438830341993 | -122.418951960739 | (37.7438830341993, -122.418951960739) | 2 | 7 | 7 | 28859 | 2 | |||
| 53526 | 23607 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 73356 | 23610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 86278 | 23605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 143584 | 23609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 177886 | 23608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 182892 | 23611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 193092 | 23606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
| 190705 | 66724 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 985 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | 16 | 3x3 | Permit Number 29967 | 6008288.03327 | 2119274.40334 | 37.7995911797528 | -122.415430833761 | (37.7995911797528, -122.415430833761) | 5 | 1 | 10 | 308 | 32 | |
| 131124 | 25363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 984 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6000603.33929 | 2088886.64942 | 37.7157189100858 | -122.439842668126 | (37.7157189100858, -122.439842668126) | 9 | 7 | 6 | 28861 | 5 | |||
| 155767 | 210438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 983 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6001071.76372 | 2096116.02375 | 37.7355957763194 | -122.438741316059 | (37.7355957763194, -122.438741316059) | 2 | 7 | 5 | 63 | 7 | |||
| 32646 | 131603 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 982 Green St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6008364.00256 | 2118971.01393 | 37.7987624175955 | -122.415146464564 | (37.7987624175955, -122.415146464564) | 5 | 1 | 10 | 308 | 32 | ||||
| 59704 | 131602 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 982 Green St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008366.73043 | 2118973.40182 | 37.7987691274466 | -122.415137194341 | (37.7987691274466, -122.415137194341) | 5 | 1 | 10 | 308 | 32 | ||||
| 88986 | 131605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 982 Green St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008358.64628 | 2118966.19584 | 37.7987488873077 | -122.415164657846 | (37.7987488873077, -122.415164657846) | 5 | 1 | 10 | 308 | 32 | ||||
| 132387 | 131604 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 982 Green St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008361.31812 | 2118968.29697 | 37.7987548066399 | -122.415155561198 | (37.7987548066399, -122.415155561198) | 5 | 1 | 10 | 308 | 32 | ||||
| 174569 | 131606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 982 Green St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6008355.15117 | 2118961.64753 | 37.7987362023609 | -122.41517642996 | (37.7987362023609, -122.41517642996) | 5 | 1 | 10 | 308 | 32 | ||||
| 2518 | 250436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5987616.8568 | 2115817.96032 | 37.7889172576592 | -122.486705722111 | (37.7889172576592, -122.486705722111) | 11 | 6 | 1 | 55 | 33 | |||
| 99385 | 111942 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987617 | 2115964 | 37.7893182489558 | -122.486715954666 | (37.7893182489558, -122.486715954666) | 11 | 6 | 1 | 55 | 33 | |||||
| 140428 | 111941 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 SEACLIFF AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5987617 | 2115964 | 37.7893182489558 | -122.486715954666 | (37.7893182489558, -122.486715954666) | 11 | 6 | 1 | 55 | 33 | ||||
| 155283 | 68800 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32739 | 5992748.00048385 | 2098471.11833094 | 37.7415852170298 | -122.467690724251 | (37.7415852170298, -122.467690724251) | 1 | 8 | 4 | 59 | 40 | ||
| 188521 | 248249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Lundy's Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6006859.99776 | 2099020.88579 | 37.7438994766787 | -122.418935096973 | (37.7438994766787, -122.418935096973) | 2 | 7 | 7 | 28859 | 2 | |||
| 144575 | 124640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5995530.71624 | 2115532.72803 | 37.7885922636435 | -122.459304361337 | (37.7885922636435, -122.459304361337) | 11 | 6 | 1 | 54 | 31 | |||
| 166671 | 124639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Arguello Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995530.66555 | 2115544.05864 | 37.7886233715196 | -122.459305357571 | (37.7886233715196, -122.459305357571) | 11 | 6 | 1 | 54 | 31 | |||
| 172910 | 124638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Arguello Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995530.63562 | 2115556.39278 | 37.788657236011 | -122.459306354681 | (37.788657236011, -122.459306354681) | 11 | 6 | 1 | 54 | 31 | |||
| 108011 | 250544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 5ft | 5988034.70999 | 2115412.27568 | 37.787827714612 | -122.485230245793 | (37.787827714612, -122.485230245793) | 11 | 6 | 1 | 55 | 33 | |||
| 114876 | 250543 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 5ft | 5988034.75992 | 2115431.27896 | 37.78787989509 | -122.485231467955 | (37.78787989509, -122.485231467955) | 11 | 6 | 1 | 55 | 33 | |||
| 122836 | 250541 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 25th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5988032.78468 | 2115471.44116 | 37.7879900539321 | -122.4852412499 | (37.7879900539321, -122.4852412499) | 11 | 6 | 1 | 55 | 33 | |||
| 127744 | 250542 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 25th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5988034.23001 | 2115456.27732 | 37.7879485025637 | -122.485235136295 | (37.7879485025637, -122.485235136295) | 11 | 6 | 1 | 55 | 33 | |||
| 51141 | 4368 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 979 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001078.79453 | 2096088.22678 | 37.7355198522892 | -122.438715016721 | (37.7355198522892, -122.438715016721) | 2 | 7 | 5 | 63 | 7 | |||
| 28619 | 69481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 975 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773682 | 5991289.37358036 | 2104918.32998629 | 37.7592032524136 | -122.473204200451 | (37.7592032524136, -122.473204200451) | 1 | 8 | 4 | 56 | 12 | |
| 47987 | 232677 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 97 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008016 | 2100005 | 37.7466666609 | -122.415007537915 | (37.7466666609, -122.415007537915) | 2 | 7 | 7 | 28859 | 2 | |||
| 106428 | 183404 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 97 Escolta Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | Permit Number 18001 | 5986872.8301 | 2097135.7376 | 37.7375776334168 | -122.487906710672 | (37.7375776334168, -122.487906710672) | 1 | 8 | 3 | 29491 | 35 | ||
| 91059 | 210036 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 969 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998385.01263 | 2095669.81816 | 37.7342173854192 | -122.44799828611 | (37.7342173854192, -122.44799828611) | 9 | 7 | 4 | 59 | 40 | |||
| 5496 | 131655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 967 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010169.62149 | 2116837.55427 | 37.7930057627679 | -122.408747818762 | (37.7930057627679, -122.408747818762) | 3 | 1 | 10 | 28857 | 4 | |||
| 115663 | 131652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 967 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010057.92943 | 2116821.15539 | 37.7929544789263 | -122.409133123422 | (37.7929544789263, -122.409133123422) | 3 | 1 | 10 | 28857 | 4 | |||
| 125131 | 131654 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 967 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010120.33438 | 2116830.14902 | 37.792982669057 | -122.408917832903 | (37.792982669057, -122.408917832903) | 3 | 1 | 10 | 28857 | 4 | |||
| 153692 | 131653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 967 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010093.37983 | 2116826.39745 | 37.7929708582625 | -122.409010832679 | (37.7929708582625, -122.409010832679) | 3 | 1 | 10 | 28857 | 4 | |||
| 98111 | 131517 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 964 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008688.6791 | 2115889.93886 | 37.7903207837283 | -122.413804917088 | (37.7903207837283, -122.413804917088) | 5 | 1 | 10 | 28858 | 21 | |||
| 72531 | 4365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 963 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6001146.94022 | 2096081.38602 | 37.7355049457015 | -122.438478921792 | (37.7355049457015, -122.438478921792) | 2 | 7 | 5 | 63 | 7 | |||
| 47555 | 121232 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000949 | 2101186 | 37.7495097486804 | -122.43952908864 | (37.7495097486804, -122.43952908864) | 2 | 4 | 5 | 28862 | 22 | |||
| 138749 | 232516 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000965.89093 | 2101191.04834 | 37.7495245715188 | -122.439471041279 | (37.7495245715188, -122.439471041279) | 2 | 4 | 5 | 28862 | 22 | |||
| 141848 | 121233 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000949 | 2101186 | 37.7495097486804 | -122.43952908864 | (37.7495097486804, -122.43952908864) | 2 | 4 | 5 | 28862 | 22 | ||||
| 170575 | 232517 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000967.63208 | 2101175.21313 | 37.7494811909162 | -122.439463885361 | (37.7494811909162, -122.439463885361) | 2 | 4 | 5 | 28862 | 22 | |||
| 182919 | 65648 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | Permit Number 28567 | 6000960.42949609 | 2101159.9986176 | 37.7494390055964 | -122.439487701536 | (37.7494390055964, -122.439487701536) | 2 | 4 | 5 | 28862 | 22 | ||
| 111227 | 82872 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52477 | 6006279.50297 | 2093770.11012 | 37.7294493094379 | -122.42056966428 | (37.7294493094379, -122.42056966428) | 9 | 7 | 7 | 28861 | 5 | |
| 151734 | 231261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 96 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6005053.12811 | 2104595.04623 | 37.7591029196827 | -122.425579474428 | (37.7591029196827, -122.425579474428) | 2 | 4 | 5 | 28859 | 19 | |||
| 94886 | 18732 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X ROOSEVELT WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001545 | 2107404 | 37.7666167714929 | -122.437913423214 | (37.7666167714929, -122.437913423214) | 15 | 5 | 5 | 28862 | 3 | |||
| 101476 | 18734 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X ROOSEVELT WAY | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001545 | 2107404 | 37.7666167714929 | -122.437913423214 | (37.7666167714929, -122.437913423214) | 15 | 5 | 5 | 28862 | 3 | |||
| 160559 | 18733 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X ROOSEVELT WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001545 | 2107404 | 37.7666167714929 | -122.437913423214 | (37.7666167714929, -122.437913423214) | 15 | 5 | 5 | 28862 | 3 | |||
| 164127 | 18735 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X ROOSEVELT WAY | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001545 | 2107404 | 37.7666167714929 | -122.437913423214 | (37.7666167714929, -122.437913423214) | 15 | 5 | 5 | 28862 | 3 | |||
| 88508 | 16567 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95X Nido Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999200.4791331 | 2112280.3747819 | 37.7798724518028 | -122.446373519186 | (37.7798724518028, -122.446373519186) | 15 | 5 | 1 | 54 | 16 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 18788 | 61569 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 958 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 12 | Permit Number 21529 | 6012748.7696 | 2103051.87566 | 37.7552975409755 | -122.398855802363 | (37.7552975409755, -122.398855802363) | 10 | 3 | 8 | 28856 | 29 | |
| 138031 | 65208 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 957 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27194 | 6003157.14364967 | 2102670.39035211 | 37.7537109599749 | -122.431999251227 | (37.7537109599749, -122.431999251227) | 2 | 4 | 5 | 28862 | 22 | ||
| 73198 | 112512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 952 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5992536.83744 | 2113485.83752 | 37.7827994832205 | -122.469513576204 | (37.7827994832205, -122.469513576204) | 11 | 6 | 2 | 54 | 11 | |||
| 48912 | 22874 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951X Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3X100 | 6009106.075934 | 2090003.4402519 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | 9 | 3 | 7 | 309 | 28 | |||
| 84345 | 38450 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 119493 | 38452 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 176250 | 38449 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 176907 | 38451 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | 10 | 3 | 8 | 58 | 1 | ||
| 66546 | 213165 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5991289.23593 | 2091020.58342 | 37.7210435845665 | -122.472191622972 | (37.7210435845665, -122.472191622972) | 9 | 8 | 6 | 64 | 24 | |||
| 58872 | 210439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6001230.41948 | 2096043.86588 | 37.7354066722857 | -122.43818761606 | (37.7354066722857, -122.43818761606) | 2 | 7 | 5 | 63 | 7 | |||
| 47864 | 52705 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/31/2006 12:00:00 AM | Permit Number 48765 | 6009564.39642774 | 2116599.60561075 | 37.7923184964294 | -122.410825126139 | (37.7923184964294, -122.410825126139) | 5 | 1 | 10 | 28857 | 21 | ||
| 94113 | 52703 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/31/2006 12:00:00 AM | Permit Number 48845 | 6009564.39642774 | 2116599.60561075 | 37.7923184964294 | -122.410825126139 | (37.7923184964294, -122.410825126139) | 5 | 1 | 10 | 28857 | 21 | ||
| 190660 | 52706 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2006 12:00:00 AM | Permit Number 48845 | 6009564.39642774 | 2116599.60561075 | 37.7923184964294 | -122.410825126139 | (37.7923184964294, -122.410825126139) | 5 | 1 | 10 | 28857 | 21 | ||
| 118258 | 177679 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Mansell St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6009054.09611 | 2089976.22082 | 37.7191880673522 | -122.410709768054 | (37.7191880673522, -122.410709768054) | 9 | 3 | 7 | 309 | 28 | |||
| 90595 | 41478 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45188 | 6015865.8609 | 2089318.7824 | 37.7177624390696 | -122.387118045326 | (37.7177624390696, -122.387118045326) | 10 | 3 | 8 | 58 | 1 | |
| 112748 | 41470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Gilman Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45188 | 6015962.09659706 | 2089242.12854286 | 37.7175572910835 | -122.38678005587 | (37.7175572910835, -122.38678005587) | 10 | 3 | 8 | 58 | 1 | ||
| 152477 | 41471 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Gilman Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45188 | 6015962.09659706 | 2089242.12854286 | 37.7175572910835 | -122.38678005587 | (37.7175572910835, -122.38678005587) | 10 | 3 | 8 | 58 | 1 | ||
| 180410 | 41479 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45188 | 6015842.107 | 2089335.2274 | 37.7178062784292 | -122.387201299125 | (37.7178062784292, -122.387201299125) | 10 | 3 | 8 | 58 | 1 |
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) );