trees
8,758 rows where qSpecies_id = 16 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 47826 | 186634 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Lower Great Hwy | 10 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980874.0957 | 2105690.7559 | 37.7607155500113 | -122.509281952349 | (37.7607155500113, -122.509281952349) | 1 | 8 | 3 | 56 | 35 | |||
| 91321 | 186519 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Lower Great Hwy | 7 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980902.9388 | 2105057.6001 | 37.758978786758 | -122.509135180581 | (37.758978786758, -122.509135180581) | 1 | 8 | 3 | 56 | 35 | |||
| 102296 | 186625 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Lower Great Hwy | 1 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980868.2988 | 2105582.371 | 37.7604176144972 | -122.50929395155 | (37.7604176144972, -122.50929395155) | 1 | 8 | 3 | 56 | 35 | |||
| 107456 | 186508 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Lower Great Hwy | 9 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980903.4565 | 2105112.4796 | 37.7591295006299 | -122.509137465432 | (37.7591295006299, -122.509137465432) | 1 | 8 | 3 | 56 | 35 | |||
| 87912 | 258213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 225X Head St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5993438 | 2087500 | 37.7115010262354 | -122.4645085409 | (37.7115010262354, -122.4645085409) | 9 | 8 | 4 | 64 | 24 | ||||
| 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 | |||
| 6885 | 259563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
| 1677 | 259282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 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 | ||
| 3318 | 185278 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984958.2606 | 2097437.8471 | 37.7382952768032 | -122.49454845339 | (37.7382952768032, -122.49454845339) | 1 | 8 | 3 | 29491 | 35 | |||
| 3330 | 213252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.7185836258199 | -122.4699185829 | (37.7185836258199, -122.4699185829) | 9 | 8 | 6 | 64 | 24 | |||
| 4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 5115 | 260959 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 9ft | 5996243 | 2114742 | 37.7864620624436 | -122.456782770891 | (37.7864620624436, -122.456782770891) | 11 | 6 | 1 | 54 | 31 | ||||
| 5512 | 259281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 6824 | 185239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2519 44th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5982695.2777 | 2097952.3458 | 37.7395752424776 | -122.502410672836 | (37.7395752424776, -122.502410672836) | 1 | 8 | 3 | 29491 | 35 | |||
| 10423 | 259280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 11003 | 232475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001440.92645 | 2099668.37427 | 37.7453706938136 | -122.437719318387 | (37.7453706938136, -122.437719318387) | 2 | 7 | 5 | 63 | 22 | |||
| 11528 | 213133 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5997236.23471 | 2094134.25097 | 37.7299353516323 | -122.451859215049 | (37.7299353516323, -122.451859215049) | 9 | 7 | 4 | 28861 | 40 | ||||
| 15037 | 262257 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 17697 | 210454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 5998090.15261 | 2091532.80921 | 37.7228412744865 | -122.448719834659 | (37.7228412744865, -122.448719834659) | 9 | 7 | 4 | 28861 | 24 | |||
| 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 | |||
| 20144 | 232263 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 122 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6002994.96825 | 2097111.77567 | 37.7384391070712 | -122.432163155731 | (37.7384391070712, -122.432163155731) | 2 | 7 | 5 | 63 | 7 | |||
| 20231 | 210441 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 62 Paradise Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000989.00514 | 2096059.11065 | 37.7354347976777 | -122.439023365936 | (37.7354347976777, -122.439023365936) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 22302 | 213174 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1385 Holloway Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5991471.72957 | 2091205.18544 | 37.7215610158113 | -122.471574247351 | (37.7215610158113, -122.471574247351) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | |||
| 25657 | 185376 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Vicente St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5983716.4012 | 2097424.0248 | 37.7381845630473 | -122.498841103792 | (37.7381845630473, -122.498841103792) | 1 | 8 | 3 | 29491 | 35 | |||
| 26653 | 131315 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3805 Sacramento St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 7ft | 5996286.23718 | 2114889.77399 | 37.7868702927873 | -122.456643872732 | (37.7868702927873, -122.456643872732) | 11 | 6 | 1 | 54 | 31 | |||
| 27414 | 186604 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984777.686 | 2104434.4069 | 37.7574953477086 | -122.495688715119 | (37.7574953477086, -122.495688715119) | 1 | 8 | 3 | 56 | 35 | |||
| 27465 | 131563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 White St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007077.34616 | 2118630.96182 | 37.7977563289566 | -122.419574581498 | (37.7977563289566, -122.419574581498) | 5 | 1 | 10 | 28858 | 32 | |||
| 28499 | 185065 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Crestlake Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5987046.1967 | 2096207.6545 | 37.7350394726269 | -122.48723916054 | (37.7350394726269, -122.48723916054) | 1 | 8 | 3 | 64 | 35 | |||
| 28622 | 186998 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984960.3769 | 2098076.3418 | 37.7400485355419 | -122.49458819362 | (37.7400485355419, -122.49458819362) | 1 | 8 | 3 | 29491 | 35 | |||
| 30066 | 131313 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996309.37683 | 2114891.39847 | 37.7868760817139 | -122.456563932896 | (37.7868760817139, -122.456563932896) | 11 | 6 | 1 | 54 | 31 | |||
| 31819 | 210035 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 419 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5998676.80384 | 2095225.65074 | 37.7330144819132 | -122.44695752318 | (37.7330144819132, -122.44695752318) | 9 | 7 | 4 | 59 | 40 | |||
| 35086 | 210455 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 5998116.37088 | 2091530.9557 | 37.7228376843924 | -122.448629070596 | (37.7228376843924, -122.448629070596) | 9 | 7 | 4 | 28861 | 24 | |||
| 36581 | 185289 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984967.0538 | 2097383.413 | 37.7381463300086 | -122.494514039619 | (37.7381463300086, -122.494514039619) | 1 | 8 | 3 | 29491 | 35 | |||
| 38437 | 187337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985071.5674 | 2099684.5129 | 37.7444706465068 | -122.494322257835 | (37.7444706465068, -122.494322257835) | 1 | 8 | 3 | 29491 | 35 | |||
| 43437 | 186995 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984978.1998 | 2098092.8196 | 37.7400948222853 | -122.494527784666 | (37.7400948222853, -122.494527784666) | 1 | 8 | 3 | 29491 | 35 | |||
| 46722 | 186986 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984962.5627 | 2098118.8813 | 37.7401654654917 | -122.494583771373 | (37.7401654654917, -122.494583771373) | 1 | 8 | 3 | 29491 | 35 | |||
| 47136 | 185063 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 Crestlake Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 0ft | 5989067.2897 | 2096124.6086 | 37.7349290995059 | -122.480245525571 | (37.7349290995059, -122.480245525571) | 1 | 8 | 3 | 64 | 35 | |||
| 48001 | 185066 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Crestlake Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5987075.6475 | 2096199.9602 | 37.7350200634269 | -122.487136775025 | (37.7350200634269, -122.487136775025) | 1 | 8 | 3 | 64 | 35 | |||
| 49593 | 185277 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984959.9355 | 2097442.0343 | 37.738306871759 | -122.494542971086 | (37.738306871759, -122.494542971086) | 1 | 8 | 3 | 29491 | 35 | |||
| 49980 | 232266 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 Digby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6003164.66759 | 2097188.08458 | 37.7386582538627 | -122.431581864513 | (37.7386582538627, -122.431581864513) | 2 | 7 | 5 | 63 | 7 | ||||
| 51566 | 185367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Wawona St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5983890.4172 | 2096823.9573 | 37.7365471449614 | -122.498195147303 | (37.7365471449614, -122.498195147303) | 1 | 8 | 3 | 29491 | 35 | |||
| 54613 | 131321 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 74 Collins St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5998164.84949 | 2114161.22093 | 37.784977559806 | -122.450091807118 | (37.784977559806, -122.450091807118) | 15 | 6 | 1 | 54 | 31 | |||
| 54693 | 185373 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Wawona St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983730.9017 | 2096817.0859 | 37.7365189235088 | -122.498746144318 | (37.7365189235088, -122.498746144318) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||
| 58473 | 185129 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2615 45th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5982406.6772 | 2097293.1784 | 37.7377483874764 | -122.503359716554 | (37.7377483874764, -122.503359716554) | 1 | 8 | 3 | 29491 | 35 | |||
| 58699 | 232265 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 138 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6002895.58733 | 2097207.34729 | 37.7386958895965 | -122.432513590926 | (37.7386958895965, -122.432513590926) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||
| 61705 | 185378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Vicente St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5983792.5487 | 2097426.4127 | 37.7381955856127 | -122.49857800406 | (37.7381955856127, -122.49857800406) | 1 | 8 | 3 | 29491 | 35 | |||
| 63086 | 185377 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Vicente St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5983769.731 | 2097427.474 | 37.7381971614622 | -122.498656973474 | (37.7381971614622, -122.498656973474) | 1 | 8 | 3 | 29491 | 35 | |||
| 63218 | 185300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984968.9381 | 2097336.9346 | 37.7380188230683 | -122.494504099425 | (37.7380188230683, -122.494504099425) | 1 | 8 | 3 | 29491 | 35 | |||
| 63382 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | MTA 3 | 37 | 5998700.41574 | 2091522.98281 | 37.7228491714484 | -122.446609585371 | (37.7228491714484, -122.446609585371) | 9 | 7 | 6 | 28861 | 25 | ||||
| 64999 | 187000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984967.1025 | 2098070.9613 | 37.7400341557766 | -122.49456454305 | (37.7400341557766, -122.49456454305) | 1 | 8 | 3 | 29491 | 35 | |||
| 65485 | 131333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 265 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6002225.92805 | 2121872.37078 | 37.806381921855 | -122.43659393376 | (37.806381921855, -122.43659393376) | 13 | 9 | 1 | 57 | 17 | |||
| 66159 | 185369 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Wawona St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983833.9732 | 2096823.9573 | 37.7365438352192 | -122.498390295245 | (37.7365438352192, -122.498390295245) | 1 | 8 | 3 | 29491 | 35 | |||
| 69836 | 131387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2611 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6000646.85309 | 2117337.12394 | 37.7938394783612 | -122.441732897381 | (37.7938394783612, -122.441732897381) | 13 | 9 | 1 | 57 | 27 | |||
| 69872 | 119972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 634 28th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5987253.43236 | 2111593.97128 | 37.7772981958937 | -122.487652666537 | (37.7772981958937, -122.487652666537) | 11 | 6 | 2 | 55 | 26 | |||
| 70248 | 185288 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984955.3296 | 2097388.8564 | 37.7381605899386 | -122.494554976628 | (37.7381605899386, -122.494554976628) | 1 | 8 | 3 | 29491 | 35 | |||
| 70324 | 185741 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2128 Lower Great Hwy | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5981273.1352 | 2100554.4124 | 37.746636127094 | -122.507520759124 | (37.746636127094, -122.507520759124) | 1 | 8 | 3 | 29491 | 35 | |||
| 71499 | 177739 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 Santa Ysabel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000624.058 | 2093290.87747 | 37.72781309909 | -122.440086683861 | (37.72781309909, -122.440086683861) | 9 | 7 | 6 | 28861 | 25 | |||
| 73289 | 210443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 62 Paradise Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000971.35263 | 2096064.29999 | 37.7354480419767 | -122.439084768942 | (37.7354480419767, -122.439084768942) | 2 | 7 | 5 | 63 | 7 | |||
| 74039 | 185285 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984965.7977 | 2097406.0241 | 37.7382083405088 | -122.494520048906 | (37.7382083405088, -122.494520048906) | 1 | 8 | 3 | 29491 | 35 | |||
| 75215 | 187005 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984963.7397 | 2098055.8287 | 37.7399924089099 | -122.494575054763 | (37.7399924089099, -122.494575054763) | 1 | 8 | 3 | 29491 | 35 | |||
| 78911 | 210057 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 149 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5999094.10957 | 2093757.83451 | 37.729008035489 | -122.445409289011 | (37.729008035489, -122.445409289011) | 9 | 7 | 4 | 28861 | 40 | |||
| 80052 | 210032 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 307 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6000730.775 | 2095077.962 | 37.7327260954171 | -122.439845838233 | (37.7327260954171, -122.439845838233) | 9 | 7 | 5 | 63 | 40 | |||
| 80736 | 186994 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984975.3414 | 2098101.0584 | 37.7401172765185 | -122.494538274902 | (37.7401172765185, -122.494538274902) | 1 | 8 | 3 | 29491 | 35 | |||
| 82172 | 186987 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984949.7841 | 2098112.1557 | 37.7401462508806 | -122.494627458243 | (37.7401462508806, -122.494627458243) | 1 | 8 | 3 | 29491 | 35 | |||
| 82705 | 210426 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 155 Brentwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5995475.97759 | 2095557.35564 | 37.7337418751857 | -122.458047544471 | (37.7337418751857, -122.458047544471) | 9 | 7 | 4 | 59 | 40 | |||
| 83521 | 185287 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984963.7041 | 2097394.2998 | 37.7381760261937 | -122.494526423373 | (37.7381760261937, -122.494526423373) | 1 | 8 | 3 | 29491 | 35 | |||
| 84394 | 177737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000610.73468 | 2093300.56234 | 37.7278389330103 | -122.44013343693 | (37.7278389330103, -122.44013343693) | 9 | 7 | 6 | 28861 | 25 | |||
| 85630 | 186984 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984939.6957 | 2098117.1999 | 37.740159510416 | -122.494662711103 | (37.740159510416, -122.494662711103) | 1 | 8 | 3 | 29491 | 35 | |||
| 88500 | 210058 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 442 Circular Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5999730.86148 | 2093694.93358 | 37.7288716532859 | -122.44320348048 | (37.7288716532859, -122.44320348048) | 9 | 7 | 4 | 63 | 40 | |||
| 88566 | 185375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Vicente St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5983693.5835 | 2097421.9022 | 37.7381773965939 | -122.498919838037 | (37.7381773965939, -122.498919838037) | 1 | 8 | 3 | 29491 | 35 | |||
| 88619 | 186985 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984954.492 | 2098122.9167 | 37.7401760732424 | -122.494611973595 | (37.7401760732424, -122.494611973595) | 1 | 8 | 3 | 29491 | 35 | |||
| 89876 | 186983 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984941.3771 | 2098124.5981 | 37.7401799222955 | -122.494657442871 | (37.7401799222955, -122.494657442871) | 1 | 8 | 3 | 29491 | 35 | |||
| 90578 | 187108 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985154.9931 | 2097244.7147 | 37.7377764992933 | -122.493854030446 | (37.7377764992933, -122.493854030446) | 1 | 8 | 3 | 29491 | 35 | |||
| 90636 | 187079 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985152.1718 | 2096955.9995 | 37.7369835995027 | -122.49384251461 | (37.7369835995027, -122.49384251461) | 1 | 8 | 3 | 29491 | 35 | |||
| 91122 | 185016 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985035.6199 | 2096418.3594 | 37.7355005636265 | -122.494205864773 | (37.7355005636265, -122.494205864773) | 1 | 8 | 3 | 29491 | 35 | |||
| 91211 | 184565 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4045 Moraga St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5981678.1974 | 2103481.7992 | 37.7546977608395 | -122.506337164847 | (37.7546977608395, -122.506337164847) | 1 | 8 | 3 | 56 | 35 | |||
| 93188 | 131316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3805 Sacramento St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 5996272.99689 | 2114886.70083 | 37.7868610945112 | -122.456689458461 | (37.7868610945112, -122.456689458461) | 11 | 6 | 1 | 54 | 31 | |||
| 93281 | 232257 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 339 Addison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6002207.39978 | 2097695.06834 | 37.7399960088977 | -122.434927884815 | (37.7399960088977, -122.434927884815) | 2 | 7 | 5 | 63 | 7 | |||
| 96473 | 185365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Wawona St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5983933.1183 | 2096826.4114 | 37.7365563869346 | -122.498047694853 | (37.7365563869346, -122.498047694853) | 1 | 8 | 3 | 29491 | 35 | |||
| 98420 | 187002 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984950.9611 | 2098062.218 | 37.7400092042874 | -122.494619708142 | (37.7400092042874, -122.494619708142) | 1 | 8 | 3 | 29491 | 35 | |||
| 99386 | 186242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1701 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984785.2956 | 2103243.6568 | 37.7542263235306 | -122.495574573749 | (37.7542263235306, -122.495574573749) | 1 | 8 | 3 | 56 | 35 | |||
| 102730 | 232581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 592 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6002779.54002 | 2099795.40963 | 37.7457955263407 | -122.433099689903 | (37.7457955263407, -122.433099689903) | 2 | 7 | 5 | 63 | 22 | |||
| 103870 | 185379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Vicente St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5983809.5293 | 2097427.474 | 37.7381994954845 | -122.498519372869 | (37.7381994954845, -122.498519372869) | 1 | 8 | 3 | 29491 | 35 | |||
| 104427 | 131642 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 California St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6011264.79438 | 2116619.39305 | 37.7924680239299 | -122.404943073171 | (37.7924680239299, -122.404943073171) | 5 | 1 | 10 | 28857 | 6 | |||
| 105420 | 131564 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 White St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007074.96838 | 2118645.83701 | 37.7977970385612 | -122.419583865222 | (37.7977970385612, -122.419583865222) | 5 | 1 | 10 | 28858 | 32 | |||
| 111232 | 177609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 285 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5998226.33803 | 2088733.92409 | 37.7151639690054 | -122.448047648095 | (37.7151639690054, -122.448047648095) | 9 | 7 | 6 | 28861 | 25 | |||
| 111852 | 186336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984805.3836 | 2102872.0286 | 37.7532071113593 | -122.495477698282 | (37.7532071113593, -122.495477698282) | 1 | 8 | 3 | 56 | 35 | |||
| 112515 | 213264 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 412 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993268.14803 | 2089869.94743 | 37.7179985412884 | -122.465267625607 | (37.7179985412884, -122.465267625607) | 9 | 8 | 6 | 64 | 24 | |||
| 113234 | 177738 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 Santa Ysabel Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000617.66463 | 2093295.25318 | 37.7278247498069 | -122.440109099456 | (37.7278247498069, -122.440109099456) | 9 | 7 | 6 | 28861 | 25 | |||
| 114686 | 131596 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Hyde St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 6007094.87882 | 2120403.74203 | 37.80262492397 | -122.419639759879 | (37.80262492397, -122.419639759879) | 5 | 1 | 1 | 28858 | 32 | |||
| 115691 | 210453 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998063.91282 | 2091533.61706 | 37.7228419921414 | -122.448810597838 | (37.7228419921414, -122.448810597838) | 9 | 7 | 4 | 28861 | 24 | |||
| 116569 | 210440 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 62 Paradise Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6000991.00171 | 2096058.06441 | 37.7354320385483 | -122.439016388103 | (37.7354320385483, -122.439016388103) | 2 | 7 | 5 | 63 | 7 | |||
| 118185 | 131317 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3805 Sacramento St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5996263.72029 | 2114885.49919 | 37.7868572624955 | -122.456721466216 | (37.7868572624955, -122.456721466216) | 11 | 6 | 1 | 54 | 31 |
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) );