trees
8,758 rows where qSpecies_id = 16 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15424 | 210235 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1524 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1983 12:00:00 AM | 13 | Width 3ft | Permit Number 20742 | 5990577.68593 | 2104968.58211 | 37.7592999980115 | -122.475669202369 | (37.7592999980115, -122.475669202369) | 1 | 8 | 4 | 56 | 12 | |
| 15505 | 182131 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 5987946.7845 | 2098317.4825 | 37.7408849833032 | -122.484280230772 | (37.7408849833032, -122.484280230772) | 1 | 8 | 3 | 29491 | 35 | |||
| 15520 | 183080 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2616 42nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983391.9238 | 2097182.8826 | 37.7375034148894 | -122.499945147451 | (37.7375034148894, -122.499945147451) | 1 | 8 | 3 | 29491 | 35 | |||
| 15579 | 183082 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2612 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983389.1514 | 2097225.854 | 37.7376212399918 | -122.499957908287 | (37.7376212399918, -122.499957908287) | 1 | 8 | 3 | 29491 | 35 | |||
| 15595 | 69040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1477 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 6 | Permit Number 33047 | 5984317.8775 | 2105128.1273 | 37.7593731725357 | -122.497330103941 | (37.7593731725357, -122.497330103941) | 1 | 8 | 3 | 56 | 35 | |
| 15683 | 69869 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2075 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982287.0182 | 2100994.7374 | 37.747904810916 | -122.504047526011 | (37.747904810916, -122.504047526011) | 1 | 8 | 3 | 29491 | 35 | |||
| 15855 | 73381 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982456.3495 | 2105084.8019 | 37.7591449348846 | -122.503764860601 | (37.7591449348846, -122.503764860601) | 1 | 8 | 3 | 56 | 35 | |||
| 16152 | 63923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1762 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1987 12:00:00 AM | 10 | 4x6 | Permit Number 24645 | 5981062.59870673 | 2103072.00706036 | 37.7535363264903 | -122.50843561579 | (37.7535363264903, -122.50843561579) | 1 | 8 | 3 | 56 | 35 | |
| 16188 | 184333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5984845.9035 | 2105169.4011 | 37.7595174319 | -122.495507003391 | (37.7595174319, -122.495507003391) | 1 | 8 | 3 | 56 | 35 | |||
| 16228 | 70437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2374 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983020.7059 | 2098971.1879 | 37.7423918202223 | -122.501360846382 | (37.7423918202223, -122.501360846382) | 1 | 8 | 3 | 29491 | 35 | |||
| 16274 | 184429 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3644 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5982055.1993 | 2100836.6944 | 37.7474572337919 | -122.504837422482 | (37.7474572337919, -122.504837422482) | 1 | 8 | 3 | 29491 | 35 | |||
| 16399 | 262491 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
| 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 | |
| 16451 | 186051 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984879.1089 | 2101869.2282 | 37.750458013884 | -122.495148802818 | (37.750458013884, -122.495148802818) | 1 | 8 | 3 | 29491 | 35 | |||
| 16504 | 185040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3351 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982502.3865 | 2096707.1429 | 37.7361449199022 | -122.50298543636 | (37.7361449199022, -122.50298543636) | 1 | 8 | 3 | 29491 | 35 | |||
| 17016 | 70361 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3933 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982619.7769 | 2104883.3949 | 37.75860153616 | -122.503184748041 | (37.75860153616, -122.503184748041) | 1 | 8 | 3 | 56 | 35 | |||
| 17060 | 209933 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2497 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992329.76263 | 2098530.09171 | 37.741722985133 | -122.469141127082 | (37.741722985133, -122.469141127082) | 1 | 8 | 4 | 29491 | 40 | |||
| 17167 | 60246 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1222 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19798 | 5988024.8183 | 2106962.3984 | 37.7646261434011 | -122.484644401305 | (37.7646261434011, -122.484644401305) | 1 | 8 | 3 | 56 | 35 | |
| 17170 | 60049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1454 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 10 | Permit Number 19547 | 5988386.7121 | 2105421.5595 | 37.7604164887691 | -122.483279765834 | (37.7604164887691, -122.483279765834) | 1 | 8 | 3 | 56 | 35 | |
| 17191 | 209959 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 170 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992766.26053 | 2098057.76441 | 37.7404513059774 | -122.467597534292 | (37.7404513059774, -122.467597534292) | 1 | 8 | 4 | 59 | 40 | |||
| 17217 | 56867 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2721 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/1974 12:00:00 AM | 16 | Permit Number 14102 | 5985533.0017 | 2102928.4495 | 37.7534046064035 | -122.492965639906 | (37.7534046064035, -122.492965639906) | 1 | 8 | 3 | 56 | 35 | ||
| 17305 | 70367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1406 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983105.9662 | 2105534.9379 | 37.7604190558161 | -122.501551512406 | (37.7604190558161, -122.501551512406) | 1 | 8 | 3 | 56 | 35 | |||
| 17342 | 60242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1265 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19794 | 5987988.4382 | 2106697.0148 | 37.7638953541046 | -122.4847507595 | (37.7638953541046, -122.4847507595) | 1 | 8 | 3 | 56 | 35 | |
| 17442 | 70357 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3827 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982346.264 | 2104189.8384 | 37.7566811453358 | -122.50407929098 | (37.7566811453358, -122.50407929098) | 1 | 8 | 3 | 56 | 35 | |||
| 17658 | 97424 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1431 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5982447.118 | 2105345.6921 | 37.7598607224916 | -122.503816109052 | (37.7598607224916, -122.503816109052) | 1 | 8 | 3 | 56 | 35 | |||
| 17732 | 60251 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19803 | 5988034.0091 | 2106629.2329 | 37.7637118975254 | -122.484588173208 | (37.7637118975254, -122.484588173208) | 1 | 8 | 3 | 56 | 35 | |
| 17777 | 219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | 1 | 8 | 4 | 64 | 35 | |||
| 17827 | 262490 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
| 17917 | 183568 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1924 Vicente St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5986954.5181 | 2097602.4506 | 37.7388638688835 | -122.487658557278 | (37.7388638688835, -122.487658557278) | 1 | 8 | 3 | 29491 | 35 | |||
| 17956 | 183322 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3927 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3 | Width 0ft | 5983510.9139 | 2106953.643 | 37.7643381938875 | -122.50025589533 | (37.7643381938875, -122.50025589533) | 1 | 8 | 3 | 56 | 35 | ||
| 17976 | 209926 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2399X 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991053 | 2099414 | 37.7440761128751 | -122.473620166067 | (37.7440761128751, -122.473620166067) | 1 | 8 | 4 | 29491 | 40 | |||
| 18167 | 210299 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1603 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993057.71013 | 2104500.81994 | 37.7581591090606 | -122.467058139841 | (37.7581591090606, -122.467058139841) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |
| 18394 | 185619 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2100 Sunset Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985000.7381 | 2100675.7371 | 37.7471881334904 | -122.49464022893 | (37.7471881334904, -122.49464022893) | 1 | 8 | 3 | 29491 | 35 | |||
| 18483 | 185660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5984916.8254 | 2100786.3456 | 37.7474869224706 | -122.494938542462 | (37.7474869224706, -122.494938542462) | 1 | 8 | 3 | 29491 | 35 | |||
| 18783 | 69008 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2118 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 6 | Permit Number 33010 | 5982340.9965 | 2100665.9606 | 37.747005255456 | -122.503836528192 | (37.747005255456, -122.503836528192) | 1 | 8 | 3 | 29491 | 35 | |
| 18849 | 183017 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3901 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983826.7685 | 2098119.8208 | 37.7401015030296 | -122.49851089564 | (37.7401015030296, -122.49851089564) | 1 | 8 | 3 | 29491 | 35 | |||
| 18929 | 76784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x12 | 5983097.2131 | 2104562.028 | 37.7577472058325 | -122.501509810878 | (37.7577472058325, -122.501509810878) | 1 | 8 | 3 | 56 | 35 | ||
| 18969 | 78173 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1203 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982086.3748 | 2106829.8545 | 37.7639145899835 | -122.505173717691 | (37.7639145899835, -122.505173717691) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 18987 | 78932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5986398.8011 | 2105011.0057 | 37.7591733303576 | -122.490124736723 | (37.7591733303576, -122.490124736723) | 1 | 8 | 3 | 56 | 35 | |||
| 19240 | 186333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 37th Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5984863.1032 | 2102341.1695 | 37.7517528980118 | -122.495238950141 | (37.7517528980118, -122.495238950141) | 1 | 8 | 3 | 56 | 35 | |||
| 19347 | 43056 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2183 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981689.1961 | 2100235.8265 | 37.7457858798003 | -122.506058471243 | (37.7457858798003, -122.506058471243) | 1 | 8 | 3 | 29491 | 35 | |
| 19460 | 184944 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 41st Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
| 19568 | 37135 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4625 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 4 | 3x3 | Permit Number 39717 | 5981309.3931 | 2106878.3636 | 37.7640020343296 | -122.507864616861 | (37.7640020343296, -122.507864616861) | 1 | 8 | 3 | 56 | 35 |
| 19571 | 71819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1226 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 5988024.8183 | 2106940.9532 | 37.7645672607667 | -122.48464282811 | (37.7645672607667, -122.48464282811) | 1 | 8 | 3 | 56 | 35 | |||
| 19626 | 70360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3826 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982955.4526 | 2104949.3397 | 37.7588023275687 | -122.502028728145 | (37.7588023275687, -122.502028728145) | 1 | 8 | 3 | 56 | 35 | |||
| 19815 | 210251 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5990831.79981 | 2105250.25751 | 37.7600881323735 | -122.474810921802 | (37.7600881323735, -122.474810921802) | 1 | 8 | 4 | 56 | 12 | |||
| 19816 | 185513 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2201 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984944.4489 | 2099918.25 | 37.7451049852144 | -122.494779030655 | (37.7451049852144, -122.494779030655) | 1 | 8 | 3 | 29491 | 35 | |||
| 20026 | 184190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1663 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5981571.9384 | 2103759.7424 | 37.7554546576042 | -122.506725244522 | (37.7554546576042, -122.506725244522) | 1 | 8 | 3 | 56 | 35 | |||
| 20040 | 95956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1245 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5990078.1094 | 2103097.6559 | 37.7541339575951 | -122.477260233088 | (37.7541339575951, -122.477260233088) | 1 | 8 | 3 | 56 | 35 | |||
| 20041 | 97746 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
| 20108 | 95282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2549 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5986028.4364 | 2102948.921 | 37.7534897766964 | -122.491253852674 | (37.7534897766964, -122.491253852674) | 1 | 8 | 3 | 56 | 35 | |||
| 20183 | 184968 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5985051.5314 | 2096639.8643 | 37.7361096880496 | -122.494167174427 | (37.7361096880496, -122.494167174427) | 1 | 8 | 3 | 29491 | 35 | |||
| 20246 | 21299 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2500X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985009.9602829 | 2098185.8984763 | 37.7403522506308 | -122.494424831045 | (37.7403522506308, -122.494424831045) | 1 | 8 | 3 | 29491 | 35 | |||
| 20395 | 210390 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995674.0593 | 2099929.55258 | 37.7457582314618 | -122.457678972627 | (37.7457582314618, -122.457678972627) | 1 | 5 | 4 | 59 | 40 | |||
| 20426 | 186848 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 0ft | 5985134.8973 | 2096546.4413 | 37.735858051355 | -122.493872066215 | (37.735858051355, -122.493872066215) | 1 | 8 | 3 | 29491 | 35 | |||
| 20452 | 21375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985033.8876136 | 2097503.4419654 | 37.7384798087017 | -122.494291809869 | (37.7384798087017, -122.494291809869) | 1 | 8 | 3 | 29491 | 35 | |||
| 20456 | 182394 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1543 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985882.7413 | 2104708.9078 | 37.7583137026984 | -122.491887252942 | (37.7583137026984, -122.491887252942) | 1 | 8 | 3 | 56 | 35 | |||
| 20471 | 184375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2292 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981760.5286 | 2099487.5935 | 37.7437356389829 | -122.505756358659 | (37.7437356389829, -122.505756358659) | 1 | 8 | 3 | 29491 | 35 | |||
| 20487 | 20789 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1703X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 10 | 5984905.3324351 | 2103602.9558617 | 37.7552198878299 | -122.495185956691 | (37.7552198878299, -122.495185956691) | 1 | 8 | 3 | 56 | 35 | |||
| 20534 | 20773 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1700X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984823.7077142 | 2103627.2778149 | 37.7552818900199 | -122.495470028613 | (37.7552818900199, -122.495470028613) | 1 | 8 | 3 | 56 | 35 | |||
| 20905 | 184249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3801 Kirkham St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982927.628 | 2104893.02 | 37.7586460549336 | -122.502120789288 | (37.7586460549336, -122.502120789288) | 1 | 8 | 3 | 56 | 35 | |||
| 20948 | 20644 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1500X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984804.3392132 | 2104951.3164434 | 37.7589161983039 | -122.495634665209 | (37.7589161983039, -122.495634665209) | 1 | 8 | 3 | 56 | 35 | |||
| 21047 | 184623 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1812 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5983822.7764 | 2102814.093 | 37.7529904508786 | -122.498871418969 | (37.7529904508786, -122.498871418969) | 1 | 8 | 3 | 56 | 35 | |||
| 21049 | 101118 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1239 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 17026 | 5990136.9434 | 2103098.5473 | 37.7541398185385 | -122.477056838029 | (37.7541398185385, -122.477056838029) | 1 | 8 | 3 | 56 | 35 | |||
| 21094 | 183605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2084 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5990088.0475 | 2101175.4275 | 37.7488566016517 | -122.477085409322 | (37.7488566016517, -122.477085409322) | 1 | 8 | 3 | 29491 | 35 | |||
| 21139 | 79277 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3010 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50040 | 5984640.9111 | 2102977.3815 | 37.7534867492857 | -122.496054240609 | (37.7534867492857, -122.496054240609) | 1 | 8 | 3 | 56 | 35 | |
| 21468 | 56542 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1633 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 5989871.3069 | 2101728.7521 | 37.7503633087611 | -122.47787533425 | (37.7503633087611, -122.47787533425) | 1 | 8 | 3 | 29491 | 35 | ||||
| 21535 | 185366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Wawona St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5983910.0499 | 2096826.4114 | 37.7365550343972 | -122.498127450923 | (37.7365550343972, -122.498127450923) | 1 | 8 | 3 | 29491 | 35 | |||
| 21654 | 177726 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989405.70354 | 2089245.56508 | 37.7160606434521 | -122.478572628528 | (37.7160606434521, -122.478572628528) | 1 | 8 | 4 | 64 | 14 | ||||
| 21826 | 184325 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1562 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982519.859 | 2104491.0565 | 37.7575184122109 | -122.503501251008 | (37.7575184122109, -122.503501251008) | 1 | 8 | 3 | 56 | 35 | |||
| 21938 | 60941 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1321 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20744 | 5990787.68033218 | 2105162.79852462 | 37.7598454365266 | -122.474957124226 | (37.7598454365266, -122.474957124226) | 1 | 8 | 4 | 56 | 12 | ||
| 21943 | 184248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3801 Kirkham St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5982906.5444 | 2104892.7144 | 37.7586439771642 | -122.502193682152 | (37.7586439771642, -122.502193682152) | 1 | 8 | 3 | 56 | 35 | |||
| 21973 | 37095 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1434 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | Permit Number 39695 | 5981563.3022 | 2105312.3785 | 37.7597172453626 | -122.506870271465 | (37.7597172453626, -122.506870271465) | 1 | 8 | 3 | 56 | 35 | |
| 22508 | 210295 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1616 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993107.09023 | 2104462.94585 | 37.7580579668146 | -122.466884610253 | (37.7580579668146, -122.466884610253) | 1 | 8 | 4 | 56 | 12 | |||
| 22603 | 209911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2435 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991685.62539 | 2098853.88166 | 37.7425747887919 | -122.471391905314 | (37.7425747887919, -122.471391905314) | 1 | 8 | 4 | 29491 | 40 | |||
| 22635 | 184577 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1723 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5983755.4304 | 2103417.8375 | 37.7546442148516 | -122.499148917367 | (37.7546442148516, -122.499148917367) | 1 | 8 | 3 | 56 | 35 | |||
| 22652 | 210353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993170.86596 | 2099198.21757 | 37.7436060548673 | -122.466281440356 | (37.7436060548673, -122.466281440356) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 22853 | 184242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1560 43rd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5982820.6822 | 2104823.8108 | 37.7584497424187 | -122.502485528067 | (37.7584497424187, -122.502485528067) | 1 | 8 | 3 | 56 | 35 | |||
| 22867 | 183332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4651 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5981239.5568 | 2106875.8545 | 37.76399103019 | -122.508105969425 | (37.76399103019, -122.508105969425) | 1 | 8 | 3 | 56 | 35 | |||
| 22967 | 107296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2690 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 12 | Permit Number 773475 | 5982185.6184 | 2096841.85092 | 37.7364961680662 | -122.504090589396 | (37.7364961680662, -122.504090589396) | 1 | 8 | 3 | 29491 | 35 | ||
| 23063 | 184339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984822.0182 | 2105860.2504 | 37.7614129124824 | -122.495640566563 | (37.7614129124824, -122.495640566563) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 23128 | 20959 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984893.4728491 | 2101578.9445242 | 37.749661815397 | -122.495077729215 | (37.749661815397, -122.495077729215) | 1 | 8 | 3 | 29491 | 35 | |||
| 23155 | 210232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1463 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990516.59592 | 2105440.14591 | 37.7605912446098 | -122.475914917858 | (37.7605912446098, -122.475914917858) | 1 | 8 | 4 | 56 | 12 | |||
| 23230 | 52576 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 5 | Permit Number 48669 | 5983504.4907 | 2102975.6894 | 37.7534154755637 | -122.499984038639 | (37.7534154755637, -122.499984038639) | 1 | 8 | 3 | 56 | 35 | |
| 23324 | 60069 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2209 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 13 | Permit Number 19569 | 5988836.6699 | 2107137.0231 | 37.7651528614771 | -122.481849248624 | (37.7651528614771, -122.481849248624) | 1 | 8 | 3 | 56 | 35 | |
| 23483 | 93742 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1701 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53320 | 5982802.7 | 2103504.9 | 37.7548273283639 | -122.502450103836 | (37.7548273283639, -122.502450103836) | 1 | 8 | 3 | 56 | 35 | ||
| 23535 | 186406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1601 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984794.1209 | 2104119.8407 | 37.7566325987037 | -122.495608676015 | (37.7566325987037, -122.495608676015) | 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 | ||
| 23636 | 186642 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Sunset Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984760.7277 | 2105189.1564 | 37.7595666865487 | -122.495803036363 | (37.7595666865487, -122.495803036363) | 1 | 8 | 3 | 56 | 35 | |||
| 23685 | 185852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 0ft | 5984979.0546 | 2101113.8863 | 37.7483899025069 | -122.494747505835 | (37.7483899025069, -122.494747505835) | 1 | 8 | 3 | 29491 | 35 | |||
| 23697 | 67745 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31364 | 5994591.15770406 | 2105174.58392635 | 37.7600974841916 | -122.461803707725 | (37.7600974841916, -122.461803707725) | 1 | 5 | 4 | 56 | 12 | ||
| 23714 | 120955 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2498x 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5985867 | 2098260 | 37.7406058338313 | -122.491467021888 | (37.7406058338313, -122.491467021888) | 1 | 8 | 3 | 29491 | 35 | ||||
| 23729 | 187003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984949.2797 | 2098059.1915 | 37.7400007959207 | -122.494625298581 | (37.7400007959207, -122.494625298581) | 1 | 8 | 3 | 29491 | 35 | |||
| 23785 | 21127 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2203X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/1997 12:00:00 AM | 3 | 10 | 5985013.3358538 | 2100217.4790898 | 37.745930619038 | -122.494562890162 | (37.745930619038, -122.494562890162) | 1 | 8 | 3 | 29491 | 35 | ||
| 24109 | 183368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3000 Quintara St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983752.8923 | 2100895.2414 | 37.7477177160252 | -122.498971329101 | (37.7477177160252, -122.498971329101) | 1 | 8 | 3 | 29491 | 35 | |||
| 24254 | 186636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Lower Great Hwy | 12 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980864.6099 | 2105729.0507 | 37.7608201372164 | -122.509317602916 | (37.7608201372164, -122.509317602916) | 1 | 8 | 3 | 56 | 35 |
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) );