trees
8,758 rows where qSpecies_id = 16 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186152 | 92965 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3650X Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Tree 1 on Rivera St | 5981790.1 | 2100170.3 | 37.7456119015234 | -122.505704709348 | (37.7456119015234, -122.505704709348) | 1 | 8 | 3 | 29491 | 35 | ||
| 191783 | 93021 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1403 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | Tree 1 on Judah | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.468484819075 | (37.7618848250494, -122.468484819075) | 1 | 8 | 4 | 56 | 12 | ||
| 109345 | 56538 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1601 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Removed on Permit No. 49327 | 5990034.81385638 | 2101735.08104673 | 37.7503901747188 | -122.477310384437 | (37.7503901747188, -122.477310384437) | 1 | 8 | 3 | 29491 | 35 | ||||
| 83914 | 99756 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 517 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Probably planted at same time/permitted with tree no. 1 | 6001837 | 2100870 | 37.7486925868246 | -122.436435749617 | (37.7486925868246, -122.436435749617) | 2 | 4 | 5 | 28862 | 22 | |||
| 29205 | 54207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 525 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9945 | 5994167.427381 | 2106639.11364061 | 37.7640943000648 | -122.463375455955 | (37.7640943000648, -122.463375455955) | 1 | 5 | 11 | 56 | 12 | |||
| 96763 | 54075 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1682 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 4 | Permit Number 9798 | 5981308.9916 | 2103651.7218 | 37.7551425766668 | -122.507626563979 | (37.7551425766668, -122.507626563979) | 1 | 8 | 3 | 56 | 35 | ||
| 191480 | 54069 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1645 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 8 | Permit Number 9792 | 5981258.5718 | 2103857.679 | 37.7557051061066 | -122.507816210489 | (37.7557051061066, -122.507816210489) | 1 | 8 | 3 | 56 | 35 | ||
| 65348 | 54065 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1632 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9788 | 5981297.9909 | 2103950.8792 | 37.7559633296946 | -122.507686804724 | (37.7559633296946, -122.507686804724) | 1 | 8 | 3 | 56 | 35 | ||
| 23609 | 54064 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1619-1621 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 19 | Permit Number 9787 | 5981254.141 | 2104003.8963 | 37.7561063161195 | -122.50784238373 | (37.7561063161195, -122.50784238373) | 1 | 8 | 3 | 56 | 35 | ||
| 81286 | 54052 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 284 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 12 | 3x3 | Permit Number 9774 | 6009944.92418425 | 2114405.86793531 | 37.7863163497004 | -122.409353602077 | (37.7863163497004, -122.409353602077) | 5 | 10 | 10 | 28852 | 36 | |
| 43468 | 53972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4535 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | 9 | Permit Number 9687 | 5981468.43648 | 2110942.49917 | 37.7751703368006 | -122.507616130998 | (37.7751703368006, -122.507616130998) | 11 | 6 | 2 | 55 | 26 | ||
| 65111 | 53961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2456 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9676 | 6002263.92073 | 2116681.11592 | 37.7921302538612 | -122.436090735194 | (37.7921302538612, -122.436090735194) | 13 | 9 | 1 | 29490 | 27 | |
| 108547 | 53960 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2450 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 17 | Permit Number 9675 | 6002267.14326 | 2116658.30598 | 37.7920678067298 | -122.436077952237 | (37.7920678067298, -122.436077952237) | 13 | 9 | 1 | 29490 | 27 | ||
| 137371 | 53905 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1092 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1972 12:00:00 AM | 14 | Permit Number 9617 | 6011225.8347 | 2089704.87272 | 37.7185645269219 | -122.403183775326 | (37.7185645269219, -122.403183775326) | 10 | 7 | 8 | 309 | 28 | ||
| 32726 | 53904 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1075 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1972 12:00:00 AM | 15 | Permit Number 9616 | 6011239.09978 | 2089785.61996 | 37.7187869832091 | -122.403143599913 | (37.7187869832091, -122.403143599913) | 10 | 7 | 8 | 309 | 28 | ||
| 154644 | 53887 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2832 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 14 | Permit Number 9598 | 6000597.06729 | 2116527.8994 | 37.7916147228868 | -122.441847053694 | (37.7916147228868, -122.441847053694) | 13 | 6 | 1 | 29490 | 27 | ||
| 190397 | 53879 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1087 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1972 12:00:00 AM | 11 | Permit Number 9590 | 6011253.4806 | 2089742.64876 | 37.7186697961475 | -122.403090869943 | (37.7186697961475, -122.403090869943) | 10 | 7 | 8 | 309 | 28 | ||
| 174078 | 53819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2838 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 16 | Permit Number 9516 | 6000579.27661 | 2116524.48723 | 37.7916043402131 | -122.441908364082 | (37.7916043402131, -122.441908364082) | 13 | 6 | 1 | 29490 | 27 | ||
| 60252 | 53818 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2820 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 16 | Permit Number 9515 | 6000665.39405 | 2116539.08536 | 37.7916493297009 | -122.441611447533 | (37.7916493297009, -122.441611447533) | 13 | 6 | 1 | 29490 | 27 | ||
| 109907 | 53794 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3501 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9486 | 5983368.4333 | 2103547.9057 | 37.7549786359111 | -122.500496852361 | (37.7549786359111, -122.500496852361) | 1 | 8 | 3 | 56 | 35 | ||
| 105205 | 53764 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 260 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1972 12:00:00 AM | Permit Number 9447 | 5992873.42694386 | 2095089.10735314 | 37.7323063039162 | -122.467011225343 | (37.7323063039162, -122.467011225343) | 9 | 8 | 4 | 59 | 40 | |||
| 174729 | 53748 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2345 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1972 12:00:00 AM | 5 | Permit Number 9428 | 6001733.38124 | 2118703.67656 | 37.797653522957 | -122.438071350827 | (37.797653522957, -122.438071350827) | 13 | 9 | 1 | 57 | 17 | ||
| 2563 | 18769 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | Permit Number 787822 | 6000600.23585 | 2106985.9234 | 37.765415066877 | -122.441151190675 | (37.765415066877, -122.441151190675) | 15 | 5 | 5 | 29492 | 3 | ||
| 194256 | 177744 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 785586 | 6001008.85116 | 2091721.5574 | 37.7235260030036 | -122.438644049011 | (37.7235260030036, -122.438644049011) | 9 | 7 | 6 | 28861 | 25 | |||
| 194260 | 177748 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 785586 | 6001125.53976 | 2091732.02705 | 37.7235613877398 | -122.438241427924 | (37.7235613877398, -122.438241427924) | 9 | 7 | 6 | 28861 | 25 | |||
| 194264 | 177747 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Permit Number 785586 | 6001098.32148 | 2091729.1423 | 37.7235519187703 | -122.438335309921 | (37.7235519187703, -122.438335309921) | 9 | 7 | 6 | 28861 | 25 | |||
| 194275 | 177745 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Permit Number 785586 | 6001030.42901 | 2091724.92182 | 37.723536468427 | -122.438569699355 | (37.723536468427, -122.438569699355) | 9 | 7 | 6 | 28861 | 25 | |||
| 194278 | 177749 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Permit Number 785586 | 6001147.04243 | 2091731.7631 | 37.7235618859526 | -122.438167078262 | (37.7235618859526, -122.438167078262) | 9 | 7 | 6 | 28861 | 25 | |||
| 194282 | 177746 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Permit Number 785586 | 6001053.43812 | 2091726.98644 | 37.7235434462625 | -122.438490308995 | (37.7235434462625, -122.438490308995) | 9 | 7 | 6 | 28861 | 25 | |||
| 18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
| 6828 | 131262 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2711 Union St | 2 | Front Yard : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 785082 | 6000010.78683 | 2118118.88771 | 37.7959497330364 | -122.443989935801 | (37.7959497330364, -122.443989935801) | 13 | 9 | 1 | 57 | 17 | ||
| 3245 | 177750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1830 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | Permit Number 784881 | 6001125.87502 | 2091373.61723 | 37.7225772947014 | -122.438214605635 | (37.7225772947014, -122.438214605635) | 9 | 7 | 6 | 28861 | 25 | ||
| 6016 | 96544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 08/29/2019 12:00:00 AM | 3 | Permit Number 784583 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.398833259061 | (37.7924495959214, -122.398833259061) | 4 | 1 | 10 | 28860 | 6 | ||
| 8345 | 258530 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2122 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784316 | 5981434 | 2100610 | 37.7467982300359 | -122.506968637856 | (37.7467982300359, -122.506968637856) | 1 | 8 | 3 | 29491 | 35 |
| 163486 | 258504 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1474 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783288 | 5981259.3327 | 2105040.90267 | 37.7589539453375 | -122.507901385569 | (37.7589539453375, -122.507901385569) | 1 | 8 | 3 | 56 | 35 | |
| 70325 | 254123 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/14/2019 12:00:00 AM | 3 | 3x15 | Permit Number 783274 | 5981986.1845 | 2100718.85597 | 37.747129621994 | -122.505067335608 | (37.747129621994, -122.505067335608) | 1 | 8 | 3 | 29491 | 35 | |
| 53182 | 258420 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2282 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783272 | 5982375.8384 | 2099583.33174 | 37.7440347055109 | -122.50363588861 | (37.7440347055109, -122.50363588861) | 1 | 8 | 3 | 29491 | 35 | |
| 152065 | 258414 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2278 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783271 | 5982374.92539 | 2099609.35071 | 37.7441060927246 | -122.503640971997 | (37.7441060927246, -122.503640971997) | 1 | 8 | 3 | 29491 | 35 | |
| 12442 | 209857 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Hillway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | Permit Number 783033 | 5996120.20407 | 2106598.58834 | 37.7640953396495 | -122.45661848128 | (37.7640953396495, -122.45661848128) | 15 | 5 | 11 | 29492 | 12 | ||
| 128693 | 257889 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1862 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782771 | 5984139.96462 | 2102494.29431 | 37.7521309716262 | -122.497750926959 | (37.7521309716262, -122.497750926959) | 1 | 8 | 3 | 56 | 35 | |
| 14148 | 89566 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782749 | 5983110.49799 | 2111681.5935 | 37.7772962731377 | -122.501990666002 | (37.7772962731377, -122.501990666002) | 11 | 6 | 2 | 55 | 26 |
| 126498 | 231439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101x Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | Permit Number 782331 | 5999775.11781 | 2101292.59964 | 37.7497355659558 | -122.443596051626 | (37.7497355659558, -122.443596051626) | 2 | 4 | 5 | 28862 | 38 | ||
| 132685 | 231438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101x Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | Permit Number 782331 | 5999777.38069 | 2101303.64449 | 37.7497660214977 | -122.443589019842 | (37.7497660214977, -122.443589019842) | 2 | 4 | 5 | 28862 | 38 | ||
| 142370 | 231440 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101x Portola Dr | 3 | Median : Cutout | Tree | Private 2 | 27 | Width 5ft | Permit Number 782331 | 5999772.05051 | 2101277.39678 | 37.7496936476461 | -122.44360556645 | (37.7496936476461, -122.44360556645) | 2 | 4 | 5 | 28862 | 38 | ||
| 38404 | 258531 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4341 Kirkham St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782234 | 5981427.35617 | 2104849.55351 | 37.7584384536263 | -122.507306095471 | (37.7584384536263, -122.507306095471) | 1 | 8 | 3 | 56 | 35 | |
| 22749 | 184649 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | Permit Number 782197 | 5983169.0582 | 2103665.8835 | 37.7552908641291 | -122.501195062681 | (37.7552908641291, -122.501195062681) | 1 | 8 | 3 | 56 | 35 | ||
| 138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||
| 116592 | 56433 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/1973 12:00:00 AM | 18 | Permit Number 781802 | 5984740.27129 | 2110989.65427 | 37.7754920142977 | -122.496301771845 | (37.7754920142977, -122.496301771845) | 11 | 6 | 2 | 55 | 26 | ||
| 18284 | 258470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2414 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781119 | 5981787.508 | 2098641.53969 | 37.741414197633 | -122.505600368739 | (37.741414197633, -122.505600368739) | 1 | 8 | 3 | 29491 | 35 | |
| 173569 | 258211 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2131 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2019 12:00:00 AM | 3 | 3x 3 | Permit Number 781078 | 5982921.39073 | 2100620.36173 | 37.746914163779 | -122.501826234988 | (37.746914163779, -122.501826234988) | 1 | 8 | 3 | 29491 | 35 | |
| 101796 | 184542 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1701 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781063 | 5983751.3694 | 2103536.962 | 37.7549710592824 | -122.499171762793 | (37.7549710592824, -122.499171762793) | 1 | 8 | 3 | 56 | 35 |
| 147971 | 253973 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 2 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
| 163295 | 253972 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 1 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
| 62549 | 183240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2001 37th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984790.3243 | 2100348.3517 | 37.7462769046122 | -122.495343672098 | (37.7462769046122, -122.495343672098) | 1 | 8 | 3 | 29491 | 35 | |
| 66811 | 183237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2001 37th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984780.1717 | 2100543.2827 | 37.7468115375468 | -122.495393151852 | (37.7468115375468, -122.495393151852) | 1 | 8 | 3 | 29491 | 35 | |
| 104005 | 183245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2706 Rivera St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984600.1313 | 2100244.4562 | 37.7459804980853 | -122.495993663284 | (37.7459804980853, -122.495993663284) | 1 | 8 | 3 | 29491 | 35 | |
| 105830 | 183250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2107 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984200.2859 | 2100804.8827 | 37.7474958486327 | -122.497417620086 | (37.7474958486327, -122.497417620086) | 1 | 8 | 3 | 29491 | 35 | |
| 124465 | 183247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2890 Rivera St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984262.8939 | 2100232.1038 | 37.7459268239815 | -122.497158855342 | (37.7459268239815, -122.497158855342) | 1 | 8 | 3 | 29491 | 35 | |
| 84231 | 251201 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Market St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Permit Number 780227 | 6004899 | 2108432 | 37.7696295695559 | -122.426385716137 | (37.7696295695559, -122.426385716137) | 7 | 4 | 5 | 28862 | 10 | ||
| 131579 | 251203 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Market St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899 | 2108432 | 37.7696295695559 | -122.426385716137 | (37.7696295695559, -122.426385716137) | 7 | 4 | 5 | 28862 | 10 | |
| 136178 | 251202 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Market St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899 | 2108432 | 37.7696295695559 | -122.426385716137 | (37.7696295695559, -122.426385716137) | 7 | 4 | 5 | 28862 | 10 | |
| 164443 | 251204 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Market St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899 | 2108432 | 37.7696295695559 | -122.426385716137 | (37.7696295695559, -122.426385716137) | 7 | 4 | 5 | 28862 | 10 | |
| 144548 | 254740 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1814 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779958 | 5983225 | 2102757 | 37.752798609062 | -122.500934388909 | (37.752798609062, -122.500934388909) | 1 | 8 | 3 | 56 | 35 | |
| 2095 | 210451 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | Permit Number 779678 | 5998008.54618 | 2091535.2933 | 37.722843428355 | -122.449002108475 | (37.722843428355, -122.449002108475) | 9 | 7 | 4 | 28861 | 24 | ||
| 57089 | 210450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | Permit Number 779678 | 5997906.40064 | 2091534.42615 | 37.7228352049685 | -122.449355140023 | (37.7228352049685, -122.449355140023) | 9 | 7 | 4 | 28861 | 24 | ||
| 60209 | 210449 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | Permit Number 779678 | 5997879.97462 | 2091537.15935 | 37.7228411980424 | -122.449446685616 | (37.7228411980424, -122.449446685616) | 9 | 7 | 4 | 28861 | 24 | ||
| 144498 | 231241 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 779645 | 6009524.44231 | 2105223.15964 | 37.7610792095625 | -122.410159822741 | (37.7610792095625, -122.410159822741) | 2 | 4 | 7 | 28859 | 19 | ||
| 148148 | 232565 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 940 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/20/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779625 | 6000396.48544 | 2101998.8644 | 37.7517102172731 | -122.441498017841 | (37.7517102172731, -122.441498017841) | 2 | 4 | 5 | 28862 | 22 | |
| 16409 | 54948 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1531 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1972 12:00:00 AM | 15 | 6x3 | Permit Number 779312 | 5982470.8167 | 2104681.2673 | 37.7580377938942 | -122.503684942327 | (37.7580377938942, -122.503684942327) | 1 | 8 | 3 | 56 | 35 | |
| 157968 | 9904 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2019 09:05:00 AM | 3 | 3X3 | Permit Number 779094 | 6005227.80523 | 2115981.43035 | 37.7903770318133 | -122.425785821167 | (37.7903770318133, -122.425785821167) | 13 | 9 | 1 | 28858 | 27 | |
| 131951 | 31954 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 376 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779001 | 6007700.6127 | 2112534.0432 | 37.7810507733068 | -122.416985690873 | (37.7810507733068, -122.416985690873) | 7 | 9 | 9 | 28852 | 36 | ||
| 148239 | 57049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 507 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 34 | Permit Number 778890 | 5981589.12816 | 2112251.71027 | 37.7787721541621 | -122.507295790862 | (37.7787721541621, -122.507295790862) | 11 | 6 | 2 | 55 | 26 | ||
| 29291 | 117118 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4006 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Permit Number 778373 | 6001804.25600707 | 2102958.17712895 | 37.7544243620634 | -122.436698432015 | (37.7544243620634, -122.436698432015) | 2 | 4 | 5 | 28862 | 22 | |||
| 120969 | 117010 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 584X LOS PALMOS DR | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778232 | 5996394 | 2095944 | 37.7348562110144 | -122.454901614723 | (37.7348562110144, -122.454901614723) | 9 | 7 | 4 | 59 | 40 | |||
| 160912 | 117009 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 584X LOS PALMOS DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778232 | 5996394 | 2095944 | 37.7348562110144 | -122.454901614723 | (37.7348562110144, -122.454901614723) | 9 | 7 | 4 | 59 | 40 | |||
| 99952 | 100712 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777720 | 6012642.07844 | 2113780.85494 | 37.7847509558276 | -122.399978174254 | (37.7847509558276, -122.399978174254) | 6 | 2 | 9 | 28853 | 6 | |
| 14869 | 117019 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008121.68381 | 2113004.40875 | 37.782365960952 | -122.415562303882 | (37.782365960952, -122.415562303882) | 7 | 10 | 9 | 28852 | 36 | |
| 61797 | 117020 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.66588 | 37.7824049150971 | -122.415575161466 | (37.7824049150971, -122.415575161466) | 7 | 10 | 9 | 28852 | 36 | |
| 68035 | 117021 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | 7 | 10 | 9 | 28852 | 36 | |
| 77658 | 94315 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122 | 2112982 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | 7 | 10 | 9 | 28852 | 36 | |
| 81347 | 117017 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | 7 | 10 | 9 | 28852 | 36 | |
| 97662 | 117018 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.66458 | 2112987.05621 | 37.7823185388132 | -122.415547303188 | (37.7823185388132, -122.415547303188) | 7 | 10 | 9 | 28852 | 36 | |
| 16618 | 251060 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5418 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990225.155 | 2112720.9896 | 37.7805655538274 | -122.477455019941 | (37.7805655538274, -122.477455019941) | 11 | 6 | 2 | 55 | 26 | ||
| 1974 | 114892 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2226 45TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777232 | 5982390 | 2099932 | 37.7449928846436 | -122.503612737002 | (37.7449928846436, -122.503612737002) | 1 | 8 | 3 | 29491 | 35 | |
| 102117 | 97324 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1033 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777184 | 5990033 | 2099023 | 37.7429434037475 | -122.477118493804 | (37.7429434037475, -122.477118493804) | 1 | 8 | 3 | 29491 | 35 | |
| 176306 | 59223 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 776927 | 6004453.04119062 | 2107386.89201253 | 37.7667347361581 | -122.427853793475 | (37.7667347361581, -122.427853793475) | 8 | 4 | 5 | 28862 | 3 | |||
| 1919 | 98261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 676 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 776653 | 5981365.73942 | 2111125.46261 | 37.775666650072 | -122.507984958591 | (37.775666650072, -122.507984958591) | 11 | 6 | 2 | 55 | 26 | ||
| 188449 | 113312 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 90 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776373 | 5991464 | 2104574.1 | 37.7582681973515 | -122.472575167246 | (37.7582681973515, -122.472575167246) | 1 | 8 | 4 | 56 | 12 | ||||
| 125726 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 63 Potomac St | 1 | Front Yard : Yard | Tree | Private 2 | 4x4 | Permit Number 776311 | 6003081 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | 15 | 5 | 5 | 29492 | 9 | |||
| 173615 | 115821 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2534 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775909 | 5981530.3 | 2097817.5 | 37.7391364720768 | -122.506428594252 | (37.7391364720768, -122.506428594252) | 1 | 8 | 3 | 29491 | 35 | ||
| 72773 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2224 Baker St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | 13 | 6 | 1 | 29490 | 27 | |||
| 165675 | 60410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1504 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775413 | 6015728.8358 | 2094304.4734 | 37.7314445748323 | -122.387939390578 | (37.7314445748323, -122.387939390578) | 10 | 3 | 8 | 58 | 1 | |
| 90133 | 115177 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775153 | 5981811.5 | 2105259.8 | 37.7595874928179 | -122.506007994714 | (37.7595874928179, -122.506007994714) | 1 | 8 | 3 | 56 | 35 | |||
| 104613 | 89263 | Section 143 10 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |
| 9347 | 114899 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 774413 | 5981525.9 | 2104542.4 | 37.7576009016243 | -122.506942509341 | (37.7576009016243, -122.506942509341) | 1 | 8 | 3 | 56 | 35 | |||
| 164222 | 112767 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 225 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774174 | 5995311.1 | 2091471.4 | 37.7225133523911 | -122.458321927922 | (37.7225133523911, -122.458321927922) | 9 | 8 | 4 | 28861 | 24 | ||
| 46943 | 46403 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3725 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2014 12:00:00 AM | 3 | Permit Number 774152 | 5982443.3691 | 2102154.0013 | 37.7510970192105 | -122.503592715545 | (37.7510970192105, -122.503592715545) | 1 | 8 | 3 | 29491 | 35 | |
| 120501 | 27021 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1485 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 773912 | 6010195.43289 | 2094633.08304 | 37.7320387642645 | -122.407092656994 | (37.7320387642645, -122.407092656994) | 10 | 3 | 7 | 309 | 28 | ||
| 5171 | 108539 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.73133 | 37.710752810564 | -122.400402802668 | (37.710752810564, -122.400402802668) | 10 | 3 | 8 | 309 | 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) );