trees
5,723 rows where qSpecies_id = 14 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86995 | 52550 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1527 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | Permit Number 782739 | 5984635.73167971 | 2104787.38586659 | 37.7584562156449 | -122.496205685195 | (37.7584562156449, -122.496205685195) | 1 | 8 | 3 | 56 | 35 | |
12115 | 115003 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004325.9 | 2096691 | 37.737359123084 | -122.42753146954 | (37.737359123084, -122.42753146954) | 2 | 7 | 5 | 63 | 7 | |||
111189 | 115001 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | Permit Number 775910 | 5993155.2 | 2098864.2 | 37.7426880232123 | -122.46631133897 | (37.7426880232123, -122.46631133897) | 1 | 8 | 4 | 59 | 40 | |||
162493 | 60670 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.427511338031 | (37.737354818402, -122.427511338031) | 2 | 7 | 5 | 63 | 7 | ||
57583 | 102176 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 488 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769768 | 5999452.4 | 2104200.8 | 37.7577023616885 | -122.444921049841 | (37.7577023616885, -122.444921049841) | 2 | 5 | 5 | 28862 | 3 |
27384 | 92968 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 633 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 53126 | 6011005.62443 | 2105237.52143 | 37.7612015551355 | -122.405038037972 | (37.7612015551355, -122.405038037972) | 10 | 3 | 8 | 28856 | 29 | |
18452 | 108642 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Judson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | 9 | 7 | 4 | 28861 | 40 | |
49227 | 108638 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 414 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.21639 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | 9 | 7 | 4 | 59 | 40 | |
65465 | 98181 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 574 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2011 12:00:00 AM | 4 | 2.5x5 | 6009895.13755 | 2111712.30885 | 37.7789176859509 | -122.409335696583 | (37.7789176859509, -122.409335696583) | 14 | 2 | 9 | 28853 | 34 | ||
131632 | 47424 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 843 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2009 12:00:00 AM | 6 | Permit Number 53122 | 5984459.81108 | 2110102.97332 | 37.7730410098098 | -122.497206468755 | (37.7730410098098, -122.497206468755) | 11 | 6 | 2 | 55 | 26 | ||
46577 | 86562 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2207 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987900.988811 | 2100267.110901 | 37.746235480683 | -122.484581545679 | (37.746235480683, -122.484581545679) | 1 | 8 | 3 | 29491 | 35 | ||
77402 | 86563 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2215 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987902.745463 | 2100215.048221 | 37.7460926326953 | -122.484571653291 | (37.7460926326953, -122.484571653291) | 1 | 8 | 3 | 29491 | 35 | ||
98007 | 86566 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2291 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987915.7374 | 2099735.4596 | 37.7447765661609 | -122.484491558794 | (37.7447765661609, -122.484491558794) | 1 | 8 | 3 | 29491 | 35 | ||
18630 | 39605 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4731 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41008 | 5998534.61450841 | 2105650.4500048 | 37.7616303166929 | -122.448199498117 | (37.7616303166929, -122.448199498117) | 15 | 5 | 11 | 29492 | 12 | ||
39139 | 32754 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 518 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41062 | 5995930.70396007 | 2088752.73433833 | 37.7150841234911 | -122.455983662757 | (37.7150841234911, -122.455983662757) | 9 | 8 | 6 | 28861 | 24 | ||
169187 | 39687 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 511 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41072 | 5993229.85433358 | 2090575.93816202 | 37.7199348128758 | -122.465451246897 | (37.7199348128758, -122.465451246897) | 9 | 8 | 6 | 64 | 24 | ||
4283 | 60581 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 630 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 7 | Permit Number 20196 | 6000106.7029 | 2111118.2026 | 37.7767331402795 | -122.443155008639 | (37.7767331402795, -122.443155008639) | 15 | 5 | 11 | 29492 | 16 | |
32448 | 114973 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 125 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776087 | 5996468.6 | 2094435 | 37.7307171398869 | -122.454534722301 | (37.7307171398869, -122.454534722301) | 9 | 7 | 4 | 28861 | 40 | |||
36150 | 113586 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X AUGUSTA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3x3 | 6011271 | 2095434 | 37.7342980459086 | -122.403430493306 | (37.7342980459086, -122.403430493306) | 10 | 3 | 8 | 58 | 1 | |||
38063 | 83288 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 164 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 776115 | 5998661.46033678 | 2097891.48861403 | 37.7403333609851 | -122.447202361917 | (37.7403333609851, -122.447202361917) | 9 | 7 | 4 | 59 | 40 | ||
58025 | 114963 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 284 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776075 | 5994159.8 | 2088442 | 37.714129118114 | -122.462082099319 | (37.714129118114, -122.462082099319) | 9 | 8 | 6 | 28861 | 24 | |||
108557 | 114976 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 231 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 775532 | 5994424.6 | 2091464.1 | 37.7224423257418 | -122.461385806846 | (37.7224423257418, -122.461385806846) | 9 | 8 | 4 | 28861 | 24 | |||
26436 | 62130 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 201 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54059 | 6001174.82097 | 2092290.03948 | 37.7250963658813 | -122.438111025319 | (37.7250963658813, -122.438111025319) | 9 | 7 | 6 | 28861 | 25 |
167686 | 95119 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 6 | 3x3 | Permit Number 54046 | 6002860.87365 | 2094458.65897 | 37.7311466511867 | -122.432437345509 | (37.7311466511867, -122.432437345509) | 9 | 7 | 5 | 28861 | 25 |
183124 | 95115 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 111 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54042 | 6004702.49074 | 2094193.2145 | 37.7305220576454 | -122.426051658966 | (37.7305220576454, -122.426051658966) | 9 | 7 | 6 | 28861 | 5 |
4308 | 86471 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1814 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987856.6219 | 2102916.0794 | 37.7535062555598 | -122.484929264335 | (37.7535062555598, -122.484929264335) | 1 | 8 | 3 | 56 | 35 | ||
23307 | 86478 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.420576 | 2103380.975618 | 37.7547814420453 | -122.485040146314 | (37.7547814420453, -122.485040146314) | 1 | 8 | 3 | 56 | 35 | ||
28164 | 86552 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1807 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.5941 | 2102964.5337 | 37.7536362092428 | -122.485116198466 | (37.7536362092428, -122.485116198466) | 1 | 8 | 3 | 56 | 35 | ||
32087 | 86468 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1830 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 10 | 3x3 | 5987859.0288 | 2102813.3889 | 37.753224435288 | -122.484913407703 | (37.753224435288, -122.484913407703) | 1 | 8 | 3 | 56 | 35 | ||
34034 | 86470 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1822 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987859.0288 | 2102867.5421 | 37.7533731253955 | -122.484917380259 | (37.7533731253955, -122.484917380259) | 1 | 8 | 3 | 56 | 35 | ||
34767 | 86481 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1738 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987831.7029 | 2103459.302005 | 37.7549963468497 | -122.485055291033 | (37.7549963468497, -122.485055291033) | 1 | 8 | 3 | 56 | 35 | ||
38212 | 86551 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1801X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987806.717124 | 2103025.494361 | 37.7538037727045 | -122.485109870887 | (37.7538037727045, -122.485109870887) | 1 | 8 | 3 | 56 | 35 | ||
42487 | 86557 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1839 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987812.6165 | 2102765.0103 | 37.7530888972888 | -122.485070359602 | (37.7530888972888, -122.485070359602) | 1 | 8 | 3 | 56 | 35 | ||
53898 | 86473 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1786 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987851.8695 | 2103141.0168 | 37.7541235962339 | -122.484962200288 | (37.7541235962339, -122.484962200288) | 1 | 8 | 3 | 56 | 35 | ||
66881 | 86554 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1815 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987806.6182 | 2102907.2902 | 37.7534792101731 | -122.485101540922 | (37.7534792101731, -122.485101540922) | 1 | 8 | 3 | 56 | 35 | ||
74870 | 86472 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1810 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987855.0174 | 2102938.1418 | 37.7535667395127 | -122.484936431442 | (37.7535667395127, -122.484936431442) | 1 | 8 | 3 | 56 | 35 | ||
76997 | 86462 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1874 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x12 | 5987866.4109 | 2102544.1995 | 37.7524857435744 | -122.484868132588 | (37.7524857435744, -122.484868132588) | 1 | 8 | 3 | 56 | 35 | ||
94605 | 86474 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1774 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987847.9041 | 2103231.0884 | 37.754370677583 | -122.484982521185 | (37.754370677583, -122.484982521185) | 1 | 8 | 3 | 56 | 35 | ||
98160 | 86455 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2274 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987957.131 | 2099832.7559 | 37.7450461263907 | -122.484355563995 | (37.7450461263907, -122.484355563995) | 1 | 8 | 3 | 29491 | 35 | ||
106457 | 86465 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1842 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987862.4384 | 2102740.1818 | 37.7530236268855 | -122.484896246512 | (37.7530236268855, -122.484896246512) | 1 | 8 | 3 | 56 | 35 | ||
109562 | 86555 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1819 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987809.0175 | 2102882.3372 | 37.7534108357177 | -122.48509141307 | (37.7534108357177, -122.48509141307) | 1 | 8 | 3 | 56 | 35 | ||
111046 | 86466 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1838 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987861.6361 | 2102765.0521 | 37.753091867307 | -122.484900845395 | (37.753091867307, -122.484900845395) | 1 | 8 | 3 | 56 | 35 | ||
116041 | 86556 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1823 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987809.2575 | 2102855.2249 | 37.7533364066252 | -122.485088594036 | (37.7533364066252, -122.485088594036) | 1 | 8 | 3 | 56 | 35 | ||
130189 | 86461 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1878 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987868.3971 | 2102516.6759 | 37.7524102868503 | -122.48485924507 | (37.7524102868503, -122.48485924507) | 1 | 8 | 3 | 56 | 35 | ||
131677 | 86469 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1826 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987859.0288 | 2102838.2592 | 37.7532927224365 | -122.48491523213 | (37.7532927224365, -122.48491523213) | 1 | 8 | 3 | 56 | 35 | ||
133867 | 86457 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2254 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987953.7171 | 2099943.2812 | 37.7453494007747 | -122.484375473288 | (37.7453494007747, -122.484375473288) | 1 | 8 | 3 | 29491 | 35 | ||
134369 | 86464 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1850 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987865.2759 | 2102688.9112 | 37.7528830168804 | -122.484882672992 | (37.7528830168804, -122.484882672992) | 1 | 8 | 3 | 56 | 35 | ||
142192 | 86458 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2226 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987945.6091 | 2100121.6579 | 37.7458387037388 | -122.4844165897 | (37.7458387037388, -122.4844165897) | 1 | 8 | 3 | 29491 | 35 | ||
151850 | 86559 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1883 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102488.6083 | 37.7523305587422 | -122.485015233915 | (37.7523305587422, -122.485015233915) | 1 | 8 | 3 | 56 | 35 | ||
153800 | 86467 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1834 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987860.8339 | 2102786.7134 | 37.7531512966831 | -122.484905208537 | (37.7531512966831, -122.484905208537) | 1 | 8 | 3 | 56 | 35 | ||
156617 | 86553 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1811 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987806.7158 | 2102929.3806 | 37.7535398701446 | -122.485102824063 | (37.7535398701446, -122.485102824063) | 1 | 8 | 3 | 56 | 35 | ||
160505 | 86460 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2214 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987944.7556 | 2100194.2034 | 37.7460378447217 | -122.484424860871 | (37.7460378447217, -122.484424860871) | 1 | 8 | 3 | 29491 | 35 | ||
171493 | 86459 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2218 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987944.3289 | 2100172.8665 | 37.7459792344128 | -122.484424771638 | (37.7459792344128, -122.484424771638) | 1 | 8 | 3 | 29491 | 35 | ||
189723 | 86456 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2270 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987955.8508 | 2099858.787 | 37.7451175263471 | -122.484361899482 | (37.7451175263471, -122.484361899482) | 1 | 8 | 3 | 29491 | 35 | ||
19182 | 52510 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 59 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48617 | 6002641.59218202 | 2094292.16602598 | 37.7306770624785 | -122.43318354754 | (37.7306770624785, -122.43318354754) | 9 | 7 | 5 | 28861 | 25 | ||
65300 | 52511 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 59 Lamartine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48617 | 6002641.59218202 | 2094292.16602598 | 37.7306770624785 | -122.43318354754 | (37.7306770624785, -122.43318354754) | 9 | 7 | 5 | 28861 | 25 | ||
104117 | 52494 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 216@ CORTLAND Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48603 | 6008067.92679753 | 2097603.39470446 | 37.7400753030702 | -122.414658053624 | (37.7400753030702, -122.414658053624) | 2 | 7 | 7 | 28859 | 2 | ||
185859 | 52512 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 59 Lamartine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48617 | 6002641.59218202 | 2094292.16602598 | 37.7306770624785 | -122.43318354754 | (37.7306770624785, -122.43318354754) | 9 | 7 | 5 | 28861 | 25 | ||
33389 | 46166 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1 Hill Point Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533 | (37.7645737153289, -122.45591064533) | 15 | 5 | 11 | 29492 | 12 | |||
115545 | 46186 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 770 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44513 | 5997141.27698608 | 2107948.77875482 | 37.7678611890203 | -122.453184384627 | (37.7678611890203, -122.453184384627) | 15 | 5 | 11 | 29492 | 9 | ||
169992 | 46167 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1 Hill Point Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533 | (37.7645737153289, -122.45591064533) | 15 | 5 | 11 | 29492 | 12 | |||
183335 | 46133 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533 | (37.7645737153289, -122.45591064533) | 15 | 5 | 11 | 29492 | 12 | ||
116285 | 18868 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2245 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2014 12:05:00 PM | 3 | 3X4 | 6004021.14791 | 2115967.48717 | 37.7902704855414 | -122.429959778042 | (37.7902704855414, -122.429959778042) | 13 | 9 | 1 | 29490 | 27 | ||
44732 | 84666 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4040 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6002909.03785492 | 2101853.22745181 | 37.75145315539 | -122.432798884354 | (37.75145315539, -122.432798884354) | 2 | 4 | 5 | 28862 | 22 |
57496 | 102119 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4040 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6002911 | 2101847 | 37.7514361675639 | -122.4327916542 | (37.7514361675639, -122.4327916542) | 2 | 4 | 5 | 28862 | 22 |
91523 | 84581 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 741 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001278.96097325 | 2101957.17252492 | 37.7516459775241 | -122.438443320582 | (37.7516459775241, -122.438443320582) | 2 | 4 | 5 | 28862 | 22 | ||
95834 | 84662 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4010 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003093.38123031 | 2101863.40239846 | 37.7514915468728 | -122.432162129841 | (37.7514915468728, -122.432162129841) | 2 | 4 | 5 | 28862 | 22 |
142814 | 84580 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 741 Douglass St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001278.96097325 | 2101957.17252492 | 37.7516459775241 | -122.438443320582 | (37.7516459775241, -122.438443320582) | 2 | 4 | 5 | 28862 | 22 | ||
161731 | 102118 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4010 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003103.5 | 2101879.6 | 37.7515365953655 | -122.432128294524 | (37.7515365953655, -122.432128294524) | 2 | 4 | 5 | 28862 | 22 |
165569 | 59582 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3911 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003738.17259187 | 2101846.91300121 | 37.7514828076554 | -122.429931187142 | (37.7514828076554, -122.429931187142) | 2 | 4 | 5 | 28862 | 22 |
174795 | 84567 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3961 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003430.22054121 | 2101829.9153452 | 37.751418691406 | -122.430994909235 | (37.751418691406, -122.430994909235) | 2 | 4 | 5 | 28862 | 22 |
136829 | 11224 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1050X Ingalls St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6018109.81504 | 2094815.33919 | 37.7329789308191 | -122.379743287027 | (37.7329789308191, -122.379743287027) | 10 | 3 | 8 | 58 | 1 | ||
11742 | 86546 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1755 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987795.350523 | 2103353.479801 | 37.7547036701032 | -122.485173242268 | (37.7547036701032, -122.485173242268) | 1 | 8 | 3 | 56 | 35 | ||
51813 | 86548 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1775 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987799.879981 | 2103222.935856 | 37.7543454955224 | -122.485148000658 | (37.7543454955224, -122.485148000658) | 1 | 8 | 3 | 56 | 35 | ||
70971 | 86550 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1789 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987803.050603 | 2103131.555043 | 37.7540947731582 | -122.485130331666 | (37.7540947731582, -122.485130331666) | 1 | 8 | 3 | 56 | 35 | ||
96332 | 86538 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1711 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987785.385714 | 2103640.676502 | 37.755491654145 | -122.485228774674 | (37.755491654145, -122.485228774674) | 1 | 8 | 3 | 56 | 35 | ||
132702 | 86545 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1751 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987794.444631 | 2103379.58858 | 37.7547753049886 | -122.48517829062 | (37.7547753049886, -122.48517829062) | 1 | 8 | 3 | 56 | 35 | ||
137052 | 86547 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1763X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987797.162306 | 2103301.262218 | 37.7545604002604 | -122.485163145595 | (37.7545604002604, -122.485163145595) | 1 | 8 | 3 | 56 | 35 | ||
171896 | 86549 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1783 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987801.691765 | 2103170.718248 | 37.7542022256 | -122.485137904077 | (37.7542022256, -122.485137904077) | 1 | 8 | 3 | 56 | 35 | ||
177194 | 86540 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1723 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987788.103389 | 2103562.350121 | 37.7552767493975 | -122.485213629356 | (37.7552767493975, -122.485213629356) | 1 | 8 | 3 | 56 | 35 | ||
184232 | 86541 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1727 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987789.009281 | 2103536.241329 | 37.7552051144841 | -122.485208580935 | (37.7552051144841, -122.485208580935) | 1 | 8 | 3 | 56 | 35 | ||
9209 | 46152 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
16219 | 46153 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
51449 | 46136 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 443 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44485 | 5996136.06204982 | 2106884.90901426 | 37.7648824130994 | -122.456584340587 | (37.7648824130994, -122.456584340587) | 15 | 5 | 11 | 29492 | 12 | ||
126975 | 46135 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 443 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44485 | 5996136.06204982 | 2106884.90901426 | 37.7648824130994 | -122.456584340587 | (37.7648824130994, -122.456584340587) | 15 | 5 | 11 | 29492 | 12 | ||
184076 | 46134 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 443 Carl St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44485 | 5996136.06204982 | 2106884.90901426 | 37.7648824130994 | -122.456584340587 | (37.7648824130994, -122.456584340587) | 15 | 5 | 11 | 29492 | 12 | ||
191037 | 39706 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 737 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 41091 | 5997212.1036903 | 2094974.32927434 | 37.7322406239966 | -122.452003223944 | (37.7322406239966, -122.452003223944) | 9 | 7 | 4 | 59 | 40 | ||
89982 | 108543 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773705 | 6001182.06594 | 2092854.3647 | 37.7266462863625 | -122.43812638687 | (37.7266462863625, -122.43812638687) | 9 | 7 | 6 | 28861 | 25 |
97488 | 108547 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773709 | 6002168.78334 | 2093999.82608 | 37.7298475310412 | -122.434797220518 | (37.7298475310412, -122.434797220518) | 9 | 7 | 6 | 28861 | 25 |
136948 | 108568 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 225 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773759 | 6006239.22183 | 2092782.68354 | 37.7267357814247 | -122.420638852723 | (37.7267357814247, -122.420638852723) | 9 | 7 | 7 | 309 | 5 |
173543 | 108564 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 208 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772581 | 6010035.65523 | 2093553.92933 | 37.7290666937725 | -122.407568987434 | (37.7290666937725, -122.407568987434) | 10 | 3 | 7 | 309 | 28 |
21442 | 82199 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 387-389 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773788 | 5992147.23232 | 2112897.41844 | 37.7811613217497 | -122.470818557907 | (37.7811613217497, -122.470818557907) | 11 | 6 | 2 | 54 | 11 | |
89174 | 108512 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1621 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773655 | 5991123.73124 | 2104364.35192 | 37.7576725829923 | -122.473736652625 | (37.7576725829923, -122.473736652625) | 1 | 8 | 4 | 56 | 12 |
163902 | 108515 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1411 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773663 | 5990815.14747 | 2105785.21755 | 37.7615560250548 | -122.474907562892 | (37.7615560250548, -122.474907562892) | 1 | 8 | 4 | 56 | 12 |
48489 | 11222 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1050X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | 3 | 3X4 | 6018123.81297 | 2094772.15079 | 37.7328611160499 | -122.379691892563 | (37.7328611160499, -122.379691892563) | 10 | 3 | 8 | 58 | 1 | ||
122015 | 59326 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 130 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2015 12:00:00 AM | Permit Number 775294 | 5998173.48699395 | 2105389.83328333 | 37.7608940771819 | -122.449429707195 | (37.7608940771819, -122.449429707195) | 15 | 5 | 11 | 29492 | 12 | ||
128600 | 108416 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2835-2899X 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771183 | 6004957 | 2100749 | 37.7485371416083 | -122.425638197277 | (37.7485371416083, -122.425638197277) | 2 | 4 | 5 | 63 | 22 |
47582 | 98167 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1397 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3x3 | Permit Number 768055 | 5999068.7 | 2104521.7 | 37.7585615677968 | -122.446271120644 | (37.7585615677968, -122.446271120644) | 2 | 5 | 5 | 28862 | 3 | ||
100314 | 98166 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1395 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3x3 | Permit Number 768055 | 5999068.7 | 2104521.7 | 37.7585615677968 | -122.446271120644 | (37.7585615677968, -122.446271120644) | 2 | 5 | 5 | 28862 | 3 | ||
112596 | 98165 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 760 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768065 | 5987585.51056 | 2110747.9701 | 37.7749946773759 | -122.48644178694 | (37.7749946773759, -122.48644178694) | 11 | 6 | 2 | 55 | 26 |
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) );