trees
281 rows where qSpecies_id = 162 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1014 | 48047 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 3251 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.0003926 | 2105579.22117963 | 37.7619607946272 | -122.416104194982 | (37.7619607946272, -122.416104194982) | 2 | 4 | 7 | 28859 | 19 | ||
1143 | 29069 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1002X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 15 | 3x3 | 6004818.3149515 | 2112301.2204093 | 37.7802489436872 | -122.4269404119 | (37.7802489436872, -122.4269404119) | 7 | 9 | 11 | 28852 | 41 | ||
12338 | 85069 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 501 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818 | 2105945 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | 8 | 4 | 8 | 28859 | 19 | |||
22818 | 105631 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
22875 | 105627 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
25183 | 103240 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 | ||||
25660 | 29071 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1050X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.7525631 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | 7 | 9 | 11 | 28852 | 41 | ||
26815 | 29001 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 225X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008536.6481126 | 2109865.7521973 | 37.7737712727069 | -122.413904609778 | (37.7737712727069, -122.413904609778) | 8 | 2 | 9 | 28853 | 34 | ||
27849 | 105617 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
31387 | 105641 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
35934 | 87978 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 819 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51015 | 5999196 | 2110014.8 | 37.7736515091341 | -122.446225997678 | (37.7736515091341, -122.446225997678) | 15 | 5 | 11 | 29492 | 16 | ||
35969 | 29068 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1091X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.7810776154036 | -122.426966984587 | (37.7810776154036, -122.426966984587) | 7 | 9 | 11 | 28852 | 41 | ||
37339 | 88266 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 650 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51251 | 5997597.8 | 2108325.1 | 37.7689206253965 | -122.451632481066 | (37.7689206253965, -122.451632481066) | 15 | 5 | 11 | 29492 | 9 | ||
37753 | 105586 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
38515 | 54336 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1327 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1972 12:00:00 AM | 4x4 | Permit Number 10097 | 5994847.28834456 | 2106520.78678165 | 37.7638085505273 | -122.461015454906 | (37.7638085505273, -122.461015454906) | 15 | 5 | 11 | 56 | 12 | ||
39408 | 85072 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 501 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818 | 2105945 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | 8 | 4 | 8 | 28859 | 19 | |||
42823 | 103238 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 | ||||
43784 | 105640 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
46404 | 29015 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 13X 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007696.7579628 | 2110744.9905592 | 37.7761382468915 | -122.416872236456 | (37.7761382468915, -122.416872236456) | 8 | 2 | 9 | 28853 | 34 | ||
47561 | 86785 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1390 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2009 12:00:00 AM | 3x3 | Permit Number 52918. Tree 5 on 10th St | 6007989 | 2110462 | 37.7753776559059 | -122.415841246268 | (37.7753776559059, -122.415841246268) | 8 | 2 | 9 | 28853 | 34 | ||
49014 | 48051 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 3251 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.0003926 | 2105579.22117963 | 37.7619607946272 | -122.416104194982 | (37.7619607946272, -122.416104194982) | 2 | 4 | 7 | 28859 | 19 | ||
49523 | 105602 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
50017 | 28988 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 479 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009637.1208706 | 2108713.6945884 | 37.7706697330112 | -122.410016537501 | (37.7706697330112, -122.410016537501) | 8 | 2 | 9 | 28853 | 34 | ||
50315 | 91192 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 3251 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007819 | 2105585 | 37.7619769992638 | -122.416083853897 | (37.7619769992638, -122.416083853897) | 2 | 4 | 7 | 28859 | 19 | ||
50322 | 105628 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770812 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | |||
50389 | 105612 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
51815 | 105619 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
53070 | 85070 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 501 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818 | 2105945 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | 8 | 4 | 8 | 28859 | 19 | |||
55562 | 103196 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1119 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003336 | 2112143 | 37.7797305827723 | -122.432057116929 | (37.7797305827723, -122.432057116929) | 15 | 9 | 11 | 29490 | 41 | ||||
56567 | 29009 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 115 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008054.0284145 | 2110370.9946968 | 37.7751314325061 | -122.415609852325 | (37.7751314325061, -122.415609852325) | 8 | 2 | 9 | 28853 | 34 | ||
57084 | 7219 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1000X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
57561 | 105582 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
58466 | 105637 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
58656 | 5957 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1499X Eddy St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003438.71486 | 2112759.60085 | 37.781429437525 | -122.431745818262 | (37.781429437525, -122.431745818262) | 15 | 9 | 11 | 29490 | 41 | ||
60970 | 105638 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
62349 | 29007 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 135 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008142.7292204 | 2110278.1359743 | 37.7748814500597 | -122.415296440644 | (37.7748814500597, -122.415296440644) | 8 | 2 | 9 | 28853 | 34 | ||
64518 | 105599 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
65978 | 105597 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
66500 | 28998 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 325X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008981.5996131 | 2109399.9435755 | 37.7725172504325 | -122.412332515783 | (37.7725172504325, -122.412332515783) | 8 | 2 | 9 | 28853 | 34 | ||
67292 | 29014 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 13X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6007696.7579628 | 2110744.9905592 | 37.7761382468915 | -122.416872236456 | (37.7761382468915, -122.416872236456) | 8 | 2 | 9 | 28853 | 34 | ||
68032 | 105590 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770812 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | |||
72218 | 105610 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
72843 | 105591 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
73211 | 103237 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 | ||||
73490 | 105585 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
73792 | 29028 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 290X 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008776.8491045 | 2109541.9048667 | 37.7728955510882 | -122.413050810433 | (37.7728955510882, -122.413050810433) | 8 | 2 | 9 | 28853 | 34 | ||
75096 | 33094 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1042 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37337 | 6011188.34764682 | 2118511.3203705 | 37.7976585269153 | -122.40534087715 | (37.7976585269153, -122.40534087715) | 3 | 1 | 10 | 308 | 23 | ||
75789 | 85073 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 501 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818 | 2105945 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | 8 | 4 | 8 | 28859 | 19 | |||
79430 | 105607 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
79877 | 29012 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 41X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6007809.025662 | 2110627.4820221 | 37.7758219106803 | -122.416475545655 | (37.7758219106803, -122.416475545655) | 8 | 2 | 9 | 28853 | 34 | ||
80904 | 105583 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
81062 | 105606 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
82892 | 105600 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
84210 | 105614 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
88883 | 87641 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1002X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
89137 | 103239 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1240 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003317 | 2112564 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | 15 | 9 | 11 | 29490 | 41 | ||||
92093 | 88265 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 650 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51251 | 5997597.8 | 2108325.1 | 37.7689206253965 | -122.451632481066 | (37.7689206253965, -122.451632481066) | 15 | 5 | 11 | 29492 | 9 | ||
94365 | 57895 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1390 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | Permit Number 49662. Tree 1 on 10th St | 6007982.25227651 | 2110472.75189299 | 37.7754067987028 | -122.415865349815 | (37.7754067987028, -122.415865349815) | 8 | 2 | 9 | 28853 | 34 | |||
95278 | 29030 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 320X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008934.3454195 | 2109377.0258793 | 37.7724516720108 | -122.412494353104 | (37.7724516720108, -122.412494353104) | 8 | 2 | 9 | 28853 | 34 | ||
95329 | 105644 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
101223 | 29019 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 142 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008137.2921126 | 2110211.4410092 | 37.7746980159096 | -122.415310526382 | (37.7746980159096, -122.415310526382) | 8 | 2 | 9 | 28853 | 34 | ||
101771 | 86791 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1390 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2015 12:00:00 AM | 3x3 | Permit Number 49662. Tree 2 on 10th St. | 6007989 | 2110462 | 37.7753776559059 | -122.415841246268 | (37.7753776559059, -122.415841246268) | 8 | 2 | 9 | 28853 | 34 | ||
102227 | 105616 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
103606 | 105635 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
103867 | 105615 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
103896 | 105620 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
104095 | 105595 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
104899 | 48049 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 3251 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.0003926 | 2105579.22117963 | 37.7619607946272 | -122.416104194982 | (37.7619607946272, -122.416104194982) | 2 | 4 | 7 | 28859 | 19 | ||
105147 | 29067 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1091X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.7810776154036 | -122.426966984587 | (37.7810776154036, -122.426966984587) | 7 | 9 | 11 | 28852 | 41 | ||
107101 | 105592 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
107660 | 41072 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 265 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2013 12:00:00 AM | 14 | 3x3 | Permit Number 771003 | 6008704.93496393 | 2109691.02471397 | 37.7733009619019 | -122.41331011811 | (37.7733009619019, -122.41331011811) | 8 | 2 | 9 | 28853 | 34 |
108928 | 105594 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 | ||||
113767 | 105626 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770812 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | |||
113965 | 105639 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770812 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | |||
114218 | 105645 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
115958 | 105647 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
120640 | 105632 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
121352 | 105605 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 770812 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | |||
122963 | 12332 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1105X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004706.62549 | 2112590.71039 | 37.7810374956819 | -122.427347425327 | (37.7810374956819, -122.427347425327) | 7 | 9 | 11 | 29490 | 41 | ||
125138 | 86793 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1390 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49662. Tree 4 on 10th St | 6007989 | 2110462 | 37.7753776559059 | -122.415841246268 | (37.7753776559059, -122.415841246268) | 8 | 2 | 9 | 28853 | 34 | ||
125926 | 48050 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 3251 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.0003926 | 2105579.22117963 | 37.7619607946272 | -122.416104194982 | (37.7619607946272, -122.416104194982) | 2 | 4 | 7 | 28859 | 19 | ||
126541 | 29021 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 190 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008343.6759731 | 2109995.3829452 | 37.7741163686713 | -122.414581308234 | (37.7741163686713, -122.414581308234) | 8 | 2 | 9 | 28853 | 34 | ||
126893 | 105643 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
126960 | 49631 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1599 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | Permit Number 46484 | 6007682.84950795 | 2109131.91033963 | 37.7717083293 | -122.416806042414 | (37.7717083293, -122.416806042414) | 8 | 2 | 9 | 28853 | 19 | ||
127938 | 29013 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 13X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6007696.7579628 | 2110744.9905592 | 37.7761382468915 | -122.416872236456 | (37.7761382468915, -122.416872236456) | 8 | 2 | 9 | 28853 | 34 | ||
128325 | 105623 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
128969 | 103167 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
131254 | 88267 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 669 Shrader St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51252 | 5997547 | 2108255 | 37.7687252393927 | -122.451803136311 | (37.7687252393927, -122.451803136311) | 15 | 5 | 11 | 29492 | 9 | |||
132127 | 105622 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
132671 | 103165 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
132948 | 105630 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | ||||
133492 | 48052 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 3251 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.0003926 | 2105579.22117963 | 37.7619607946272 | -122.416104194982 | (37.7619607946272, -122.416104194982) | 2 | 4 | 7 | 28859 | 19 | ||
133848 | 27436 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1690X Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | 10 | 3 | 8 | 58 | 1 | |||
134999 | 105618 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
136402 | 105611 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
138396 | 105609 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
138711 | 103164 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1201X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | 15 | 9 | 11 | 29490 | 41 | ||||
139456 | 105608 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 401X 11th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6009144.21767 | 2108487.31593 | 37.7700205116512 | -122.41170550536 | (37.7700205116512, -122.41170550536) | 8 | 2 | 9 | 28853 | 34 | ||||
139530 | 105634 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1401X Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770812 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.411878939782 | (37.7711042533217, -122.411878939782) | 8 | 2 | 9 | 28853 | 34 | |||
140925 | 105584 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1200X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009691.5 | 2108599.6 | 37.7703595033467 | -122.409820383511 | (37.7703595033467, -122.409820383511) | 8 | 2 | 9 | 28853 | 34 |
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) );